Delete query in Embedded SQL
I have a delete query in embedded SQL. How can I know how many records are deleted?
Answer Question
| June 13, 2012 5:18 AM
Embedded SQL
I have a delete query in embedded SQL. How can I know how many records are deleted?
Answer Question
| June 13, 2012 5:18 AM
Embedded SQL
Access, Searchable Combo Box within a Form?
Hello, I’m trying to create a combo list box in an access form that has all 12 months (January, February……etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don’t want it to look at the day or the year, but only the month. Example: [...]
Answer Question
| May 25, 2012 4:48 PM
Database, Microsoft Access, MS Access
Hello, I’m trying to create a combo list box in an access form that has all 12 months (January, February……etc,) listed and depending on the selection will bring up only that particular month within a range of dates. I don’t want it to look at the day or the year, but only the month. Example: [...]
Answer Question
| May 25, 2012 4:48 PM
Database, Microsoft Access, MS Access
Creating a database from an already created database
The HR department at my place of business has created an access database that I import weekly, they have set up most of the fields. They have not used normalization. How do I proceed to create a database for my department
Answer Question
| May 24, 2012 3:19 PM
Database
The HR department at my place of business has created an access database that I import weekly, they have set up most of the fields. They have not used normalization. How do I proceed to create a database for my department
Answer Question
| May 24, 2012 3:19 PM
Database
Crystal Reports CSV with quotes inside string
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]
Answer Question
| May 24, 2012 4:26 PM
Crystal Report formula, Crystal Report XI, CSV
I need to export a CR XI report to csv. Some of the fields allow users to use double quotes to indicate inches. When exported to CSV I get something like this: “Andy”, 4685, “requires 5″ by 2″ silver plate”, 1132 According to CSV standard it should be: “Andy”, 4685, “requires 5″” by 2″” silver [...]
Answer Question
| May 24, 2012 4:26 PM
Crystal Report formula, Crystal Report XI, CSV
What Oracle 10g software is needed to download and install on the system for Running JDBC Programs on the system.
Sir what, Oracle 10g Software is needed to be downloaded from the Internet, for installing it into the system for compiling JDBC java programs. Sir please tell me the reply sir, for the running JDBC java programs.
Answer Question
| May 22, 2012 1:30 PM
JDBC, Oracle 10g
Sir what, Oracle 10g Software is needed to be downloaded from the Internet, for installing it into the system for compiling JDBC java programs. Sir please tell me the reply sir, for the running JDBC java programs.
Answer Question
| May 22, 2012 1:30 PM
JDBC, Oracle 10g
Pass table name to procedure including fields
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]
Answer Question
| May 16, 2012 5:55 AM
MySQL, MySQL Database
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]
Answer Question
| May 16, 2012 5:55 AM
MySQL, MySQL Database
Get MYSQL data on iSeries
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…
Answer Question
| May 14, 2012 8:10 AM
AS400 iseries, Linux, MySQL
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…
Answer Question
| May 14, 2012 8:10 AM
AS400 iseries, Linux, MySQL
SQL TAGS
Why am failling when am using mysql to create database and am using the exactly tags?
Answer Question
| May 27, 2012 6:54 AM
MySQL, MySQL Database
Why am failling when am using mysql to create database and am using the exactly tags?
Answer Question
| May 27, 2012 6:54 AM
MySQL, MySQL Database
datagridview
I am using vb.net and access database. I have a datagridview with 20 rows and 5 columns( filed name in access table as follows: S.no,product_code,product_name,qty.rate).I want to update all datas which I entered in the datagridview to the concernd table.. Can you plz give me the code for updating database. table name: Iteminvtbl button name ( for [...]
Answer Question
| May 9, 2012 9:04 AM
Database
I am using vb.net and access database. I have a datagridview with 20 rows and 5 columns( filed name in access table as follows: S.no,product_code,product_name,qty.rate).I want to update all datas which I entered in the datagridview to the concernd table.. Can you plz give me the code for updating database. table name: Iteminvtbl button name ( for [...]
Answer Question
| May 9, 2012 9:04 AM
Database
Creating New Data Source to SQL Server…
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
I am going into, Control Panel, Admin Tools, Data Sources (ODBC), under the, User DSN tab I’m choosing “Add…”, then choosing SQL Server. Then under server the one I need..well there are two with the same name, how can this be? A follow up question, not all accounts have access to this, but some do, [...]
Answer Question
| May 5, 2012 5:04 PM
Administrative tools, Data Sources, ODBC, SQL Server
table size strange in SQL SERVER
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl]( [IdUrl] [Int] IDENTITY(1,1) NOT NULL, [IdSupply] [Int] NOT NULL, [Url] [varchar](512) NOT NULL, [UrlCod] [varchar](256) NOT NULL, [Status] [Int] NOT NULL, [InsertionDate] [datetime] NOT NULL, [...]
Answer Question
| May 5, 2012 2:21 PM
Database, Microsoft SQL Server 2008, SQL Server
Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl]( [IdUrl] [Int] IDENTITY(1,1) NOT NULL, [IdSupply] [Int] NOT NULL, [Url] [varchar](512) NOT NULL, [UrlCod] [varchar](256) NOT NULL, [Status] [Int] NOT NULL, [InsertionDate] [datetime] NOT NULL, [...]
Answer Question
| May 5, 2012 2:21 PM
Database, Microsoft SQL Server 2008, SQL Server
VB 6.0 Database
Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me [...]
Answer Question
| May 3, 2012 8:02 AM
Microsoft Access, VB 6.0
Hi guys, I have a question about vb 6.0 database. I used ms-access to connect the database with vb project. the component I used adodc. when I try to move the project to another computer the project will say misplacing the database it lost the pathe of the db. Is there anyone can help me [...]
Answer Question
| May 3, 2012 8:02 AM
Microsoft Access, VB 6.0
Open IT Forum: Do you feel good about the IT job market?
Recently, the global human and resource firm Randstad Technologies published a survey about the IT worker’s confidence in the workplace and the economy. According to the survey, 40% of IT professionals said their confidence in the economy has improved while 32% said they believe more IT jobs are now available. After looking at these numbers, [...]
Answer Question
| May 27, 2012 5:00 PM
IT careers, IT industry
Recently, the global human and resource firm Randstad Technologies published a survey about the IT worker’s confidence in the workplace and the economy. According to the survey, 40% of IT professionals said their confidence in the economy has improved while 32% said they believe more IT jobs are now available. After looking at these numbers, [...]
Answer Question
| May 27, 2012 5:00 PM
IT careers, IT industry
Access datasheet
Can I export a parts list from BPCS to an access database?
Answer Question
| May 1, 2012 12:24 PM
BPCS, Microsoft Access
Can I export a parts list from BPCS to an access database?
Answer Question
| May 1, 2012 12:24 PM
BPCS, Microsoft Access
QEXECSQL command source
Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]
Answer Question
| May 27, 2012 9:37 AM
CSV, OS/400
Hello, I am trying to implement a command ZCPYTOCSV. THis command uses ZFFDTOCSV and ZEXECSQL commands. I have the source of ZFFDTOCSV but cannot find the source for command ZEXECSQL. If anyone has access to this – could you please let me know. Alternatively is there is another better utility for copying Database file to [...]
Answer Question
| May 27, 2012 9:37 AM
CSV, OS/400
Creating Views in MYSQL via Sysdate
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 – 14:00. I have been told that this can be [...]
Answer Question
| March 27, 2012 8:58 PM
MySQL, MySQL Database, Oracle
vb.net 2008 login using ms access
hi guys,ive been working on trying to create a login form. ms Access side: -used a logininfo.mdb database with columns :username,password,job vb 2008 side: -login form with clerk rad button,manager rad button,username text box,password textbox and login button now the challenge im having is that only the “Clerk” can login properly,ive used the same code [...]
Answer Question
| March 23, 2012 10:27 AM
Microsoft Access, VB.NET 2008
hi guys,ive been working on trying to create a login form. ms Access side: -used a logininfo.mdb database with columns :username,password,job vb 2008 side: -login form with clerk rad button,manager rad button,username text box,password textbox and login button now the challenge im having is that only the “Clerk” can login properly,ive used the same code [...]
Answer Question
| March 23, 2012 10:27 AM
Microsoft Access, VB.NET 2008
Query for records that have certain numbers in them
I have a table with 4 fields and 100 records(rows), with numbers in each field. Example would be: In Record One Fieldone has 87 fieldtwo has 94 fieldthree has 32 fieldfour has 99. than Record two has numbers in each field: Fieldone-94, Fieldtwo-33, Fieldthree-102, Fieldfour-44. I need to create a query that will show records [...]
Answer Question
| March 5, 2012 4:00 PM
Microsoft Access, Microsoft Access queries
I have a table with 4 fields and 100 records(rows), with numbers in each field. Example would be: In Record One Fieldone has 87 fieldtwo has 94 fieldthree has 32 fieldfour has 99. than Record two has numbers in each field: Fieldone-94, Fieldtwo-33, Fieldthree-102, Fieldfour-44. I need to create a query that will show records [...]
Answer Question
| March 5, 2012 4:00 PM
Microsoft Access, Microsoft Access queries
columns in table (Access)
I am trying to create a table in Access and every time i do, my field/columns are starting from the right side instead of the left side. Nobody seems to know how to change it. Help.
Answer Question
| March 5, 2012 8:15 PM
Microsoft Access, Microsoft Access tables
I am trying to create a table in Access and every time i do, my field/columns are starting from the right side instead of the left side. Nobody seems to know how to change it. Help.
Answer Question
| March 5, 2012 8:15 PM
Microsoft Access, Microsoft Access tables
vb6 using parameter
hi to everyone…. i need help on how to become a good programmer,,, i have a question,,,, are all codes in creating a program can be found on internet??? or ineed a reference book…. no i start in vb6 and ms access…. please give me an advise and relevant website to supply my ambition to [...]
Answer Question
| March 1, 2012 11:46 AM
Microsoft Access, Visual Basic 6.0
hi to everyone…. i need help on how to become a good programmer,,, i have a question,,,, are all codes in creating a program can be found on internet??? or ineed a reference book…. no i start in vb6 and ms access…. please give me an advise and relevant website to supply my ambition to [...]
Answer Question
| March 1, 2012 11:46 AM
Microsoft Access, Visual Basic 6.0
