Storing HTML in a Physical File
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
Embedded SQL Update Query
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Extra Page Printing
When I print a form I select a record but it gives me an extra page with part of the header printed with it.
Answer Question
| June 22, 2012 2:26 PM
Microsoft Access 2007, Microsoft Access printing
When I print a form I select a record but it gives me an extra page with part of the header printed with it.
Answer Question
| June 22, 2012 2:26 PM
Microsoft Access 2007, Microsoft Access printing
AS/400 Profile getting disabled by MS Access
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
We continue to have an issue where an AS/400 profile gets disabled by MS Access. This only happens sporadically (i.e not with the daily or hourly run of the scheduled tasks/jobs on the windows server). We are using ODBC linked tables to pull data from a couple of AS/400′s in to MS Access. The other [...]
Answer Question
| June 8, 2012 2:15 PM
iSeries, Microsoft Access, ODBC
GROUP BY mysql
Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.
Answer Question
| June 22, 2012 8:10 AM
MySQL, MySQL Database, MySQL query
Hi I have started working with a mySQL databse. I need a query that will either make use of “DISTINCT” or “GROUP BY” but that selectes the record that has the highest ‘VersionNumber’ Can anybody suggest how I would achieve this? Thanks in advance.
Answer Question
| June 22, 2012 8:10 AM
MySQL, MySQL Database, MySQL query
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
