Date problem with Delphi 7
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ‘ select * from datum where datum < 1994/02/05′ ; qrydate.Active := true; in she shown [...]
Answer Question
| August 31, 2009 8:48 PM
Access 2000, Access Database, Delphi 7, Microsoft Access, SQL
I am trying to select records where the date is smaller that a specific date by using Delphi 7. The data is stored in a MS access 2000 database. dtsdate.DataSet := qrydate ; qrydate.Active := false ; qrydate.SQL.Text := ‘ select * from datum where datum < 1994/02/05′ ; qrydate.Active := true; in she shown [...]
Answer Question
| August 31, 2009 8:48 PM
Access 2000, Access Database, Delphi 7, Microsoft Access, SQL
UPDATE a year from an ISO date field using SQL
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains ’2008-12-31′ and I would like to use I-Series navigator’s SQL to update the date field above with ’2007-11-31′.But my intention for the update here is to decrease/deduct the year by 1 year and the month by 1 [...]
Answer Question
| August 25, 2009 9:33 AM
AS/400 SQL, iSeries Navigator, ISO files, SQL
Dear Sir/Madam, How can I update the year from a date field. For example the date file contains ’2008-12-31′ and I would like to use I-Series navigator’s SQL to update the date field above with ’2007-11-31′.But my intention for the update here is to decrease/deduct the year by 1 year and the month by 1 [...]
Answer Question
| August 25, 2009 9:33 AM
AS/400 SQL, iSeries Navigator, ISO files, SQL
SQL auto increment by group with INSERT..
Is it possible to define an auto-incremental coloumn which increments by ‘group’ ? I want to create a version log for an old table (uniquely keyed ‘HOWTONO’) which contains records with ‘How to’ data in the form of short code-fields and some long fields with text. I intend to trigger updates, inserts and deletions from [...]
Answer Question
| August 25, 2009 11:19 AM
AS/400, Incremental backup, SQL, SQL INSERT, V6R1
Is it possible to define an auto-incremental coloumn which increments by ‘group’ ? I want to create a version log for an old table (uniquely keyed ‘HOWTONO’) which contains records with ‘How to’ data in the form of short code-fields and some long fields with text. I intend to trigger updates, inserts and deletions from [...]
Answer Question
| August 25, 2009 11:19 AM
AS/400, Incremental backup, SQL, SQL INSERT, V6R1
Bulk-Logged Recovery Model SQL Server 2005
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?
Answer Question
| August 22, 2009 5:06 PM
SQL, SQL Server 2005, SQL Server 2005 performance
If I change the recovery model on the database from full to bulk-logged to run DBCC CheckDB and Rebuild Indexes is changing the recovery model the correct thing to do?
Answer Question
| August 22, 2009 5:06 PM
SQL, SQL Server 2005, SQL Server 2005 performance
SQL cursor question
hi, i’ve SQLRPGLe program in which i’m writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees…. i’m not sure how to handle the print count part…i.e. in SQL how [...]
Answer Question
| August 20, 2009 2:24 PM
RPGLE, SQL, SQL Cursors
hi, i’ve SQLRPGLe program in which i’m writing a cursor to select all records, order them by a field A (suppose employee number). And once all the rows fetched for an employee and printed, print the count at the bottom. Repeat this for all the subsequent employees…. i’m not sure how to handle the print count part…i.e. in SQL how [...]
Answer Question
| August 20, 2009 2:24 PM
RPGLE, SQL, SQL Cursors
AS/400 SQL BLOBS
I am trying to read data from a SQL table that contains a BLOB of 10MB. Since the RPG field size is limited to 32KB, is this even possible?
Answer Question
| August 20, 2009 6:13 PM
AS/400, AS/400 SQL, BLOB, SQL
I am trying to read data from a SQL table that contains a BLOB of 10MB. Since the RPG field size is limited to 32KB, is this even possible?
Answer Question
| August 20, 2009 6:13 PM
AS/400, AS/400 SQL, BLOB, SQL
text data to packed
i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql …
Answer Question
| October 12, 2009 3:52 PM
AS/400 SQL, SQL
i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql …
Answer Question
| October 12, 2009 3:52 PM
AS/400 SQL, SQL
Using SRCDBG with an SQLRPGLE module
I’m trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program “cannot be accessed”. There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.
Answer Question
| October 11, 2009 6:32 PM
RPGLE, SQL, SQLRPGLE
I’m trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program “cannot be accessed”. There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.
Answer Question
| October 11, 2009 6:32 PM
RPGLE, SQL, SQLRPGLE
Using MS Acess SQL Passthrough To AS400 to find wholes in number sequence between to files
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I [...]
Answer Question
| August 14, 2009 5:17 PM
iSeries V6R1, Microsoft Access, SQL, V5R4
Below is a SQL statement from an Ms-access pass-through query that is pulling the info from an AS400 system. The Fields marked in bold are the two table that I need help with. This query returns the same part numbers form each of the two columns of cores because there are of differ tables. I [...]
Answer Question
| August 14, 2009 5:17 PM
iSeries V6R1, Microsoft Access, SQL, V5R4
Reformatting SQL Data in a Field
Hi, I’m new to the whole SQL experience and need help converting some data. In our Activity table, data was imported into the UF_4 field incorrectly. We want to convert this data “from a Decimal format” to a “NonDecimal”. Currently the data looks like 5234.000 and we want it to look like 5234 Thanks in advance [...]
Answer Question
| August 13, 2009 3:42 PM
SQL, SQL 2005
Hi, I’m new to the whole SQL experience and need help converting some data. In our Activity table, data was imported into the UF_4 field incorrectly. We want to convert this data “from a Decimal format” to a “NonDecimal”. Currently the data looks like 5234.000 and we want it to look like 5234 Thanks in advance [...]
Answer Question
| August 13, 2009 3:42 PM
SQL, SQL 2005
Rollback command in SQL
Suppose user x insert values into table t1,and then update the table t1. After then he wants to increase the size of column c1. Then he wants to rollback to update values. He can do this or not? If yes then what is the right procedure?
Answer Question
| April 19, 2013 3:45 AM
SQL
Suppose user x insert values into table t1,and then update the table t1. After then he wants to increase the size of column c1. Then he wants to rollback to update values. He can do this or not? If yes then what is the right procedure?
Answer Question
| April 19, 2013 3:45 AM
SQL
USROPN file in SQLRPGLE
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL statement in this [...]
Answer Question
| August 12, 2009 7:37 PM
RPGLE, SQL, USROPN
I have a SQLRPGLe program. Certain files are not available at client terminal depending upon the applications purchased by client. I have a common program called from all applications and hence i user open the files based on the application types. my confusion is if i refer a file directly in SQL statement in this [...]
Answer Question
| August 12, 2009 7:37 PM
RPGLE, SQL, USROPN
AS400 File to MS Access by SQL Passthrough Query
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM RDB.CARF1.INPFP100 INPFP100 Then would do a second query like this: (Query Two) [...]
Answer Question
| August 11, 2009 1:03 PM
AS/400, Microsoft Access, SQL, SQL Pass Through Query, V5R4, V6R1
I am trying to joint more then one File (table) from the AS400 by using MS-Access passthrough query SQL. I have been able to create separate individual queries. Like I mentioned before. I have using the below statement: (Query One) SELECT INPFP100.PFPFAM,INPFP100.PFPLIN,INPFP100.PFDES FROM RDB.CARF1.INPFP100 INPFP100 Then would do a second query like this: (Query Two) [...]
Answer Question
| August 11, 2009 1:03 PM
AS/400, Microsoft Access, SQL, SQL Pass Through Query, V5R4, V6R1
Display Bug with CFTextArea?
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows display fine [...]
Answer Question
| August 7, 2009 5:02 PM
SQL, SQL Database, SQL Display
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows display fine [...]
Answer Question
| August 7, 2009 5:02 PM
SQL, SQL Database, SQL Display
Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]
Answer Question
| August 5, 2009 2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]
Answer Question
| August 5, 2009 2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL
AS/400 SQL
want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this
Answer Question
| August 5, 2009 1:59 PM
AS/400 SQL, iSeries SQL, SQL
want to all some users to run an SQL for display only and not allow update of delete. is there a way to do this
Answer Question
| August 5, 2009 1:59 PM
AS/400 SQL, iSeries SQL, SQL
Refresh/Run SQL
We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?
Answer Question
| August 3, 2009 9:28 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database
We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?
Answer Question
| August 3, 2009 9:28 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database
SQL upload images problem
hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz…n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: —— Build started: Project: C:WebSite4, Configuration: Debug Any CPU —— Validating Web Site Building directory ‘/WebSite4/’. C:WebSite4Default.aspx.cs(35,9): error CS0246: [...]
Answer Question
| August 3, 2009 9:08 PM
Image Editor, SQL
hello glad to be here, i have a upload images tutoiral that i got from here http://geekswithblogs.net/dotNETvinz…n-asp.net.aspx but i can not get it to work, it is slightly tweaked for me. errors i am getting are: —— Build started: Project: C:WebSite4, Configuration: Debug Any CPU —— Validating Web Site Building directory ‘/WebSite4/’. C:WebSite4Default.aspx.cs(35,9): error CS0246: [...]
Answer Question
| August 3, 2009 9:08 PM
Image Editor, SQL
Finding differences between 2 files using sql
I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT ‘HPO’ as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT ‘ARC’ as Filename, PORD,PLINE from HPOARC) group by PORD, PLINE having count(*) = 1 When I try [...]
Answer Question
| August 3, 2009 2:32 PM
SQL, V5R2
I am on V5R2 and am trying to find differences between a production file and an archived file using the following sql stmt: SELECT MAX(Filename), PORD, PLINE FROM (SELECT ‘HPO’ as Filename, PORD,PLINE from HPOL01 UNION ALL SELECT ‘ARC’ as Filename, PORD,PLINE from HPOARC) group by PORD, PLINE having count(*) = 1 When I try [...]
Answer Question
| August 3, 2009 2:32 PM
SQL, V5R2
SQL select command
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, biddings.price FROM customers, biddings, auction_items, items, auctions WHERE customers.customer_nr = biddings.customer_nr AND auction_items.auction_item_nr = biddings.auction_item_nr AND items.item_nr = auction_items.item_nr AND auction_items.auction_nr = auctions.auction_nr AND auctions.auction_nr =7 ORDER [...]
Answer Question
| August 3, 2009 12:51 PM
SQL, SQL commands, SQL Select
Hi i hope all doing well, i have a problem with this SQL select command : **************************************************************** SELECT DISTINCT customers.first_name, customers.last_name, customers.email, customers.cellPhone, customers.phone, items.title, items.price, auction_items.auction_item_nr, auction_items.reserv_price, biddings.price FROM customers, biddings, auction_items, items, auctions WHERE customers.customer_nr = biddings.customer_nr AND auction_items.auction_item_nr = biddings.auction_item_nr AND items.item_nr = auction_items.item_nr AND auction_items.auction_nr = auctions.auction_nr AND auctions.auction_nr =7 ORDER [...]
Answer Question
| August 3, 2009 12:51 PM
SQL, SQL commands, SQL Select
