Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 7 of 7 total |
TEDBQuery parameters problem |
Fri, Dec 22 2006 3:16 AM | Permanent Link |
"Edhrx" | Hi,
I am using d7 enterprise / win2k prof 1: In the IDE opening TEDBQuery this works select id,surname,forenames from clients This does not select id,surname,forenames from clients where id = :id #601 CLIENTS table corrupt (error reading index pages into cache) However, if you put a default value into the parameter property it works 2: when running a test app with this in it in the onscroll event of TEDBQuery qlist I get the same error as in 1: and eventually it leads to an AV with ( qDetails ) do begin DisableControls; Active:= False; ParamByName('id').value := qList.fieldbyname('id').value Active:= True; EnableControls; end; If it helps, it fails in edbcomps.pas in function GetQueryCursor ( 7269 ) |
Fri, Dec 22 2006 3:30 AM | Permanent Link |
"Edhrx" | There may be a more general problem with creating record cursors as this
attempted run round on the parmeter problem gives the same errors with ( qDetails ) do begin DisableControls; Active:= False; sql[1] := 'where id = ' + QuotedStr(qList.fieldbyname('id').value) Active:= True; EnableControls; end; Best wishes Ed. "Edhrx" <ed@synergynewmedia.co.uk> wrote in message news:06541626-9D8C-4263-AA50-15AF91EBB9ED@news.elevatesoft.com... > Hi, > I am using d7 enterprise / win2k prof > > 1: In the IDE opening TEDBQuery this works > select id,surname,forenames from clients > > This does not > select id,surname,forenames from clients where id = :id > > #601 CLIENTS table corrupt (error reading index pages into cache) > > However, if you put a default value into the parameter property it works > > > 2: when running a test app with this in it in the onscroll event of > TEDBQuery qlist > I get the same error as in 1: and eventually it leads to an AV > > with ( qDetails ) do > begin > DisableControls; > Active:= False; > ParamByName('id').value := qList.fieldbyname('id').value > Active:= True; > EnableControls; > end; > > If it helps, it fails in edbcomps.pas in function GetQueryCursor ( 7269 ) > > |
Fri, Dec 22 2006 3:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ed,
I will look into these issues and make sure they're addressed. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Dec 29 2006 2:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << This does not select id,surname,forenames from clients where id = :id #601 CLIENTS table corrupt (error reading index pages into cache) However, if you put a default value into the parameter property it works >> Could you possibly send me the table that you're using ? I can't get anything bad to happen with parameterized queries here. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Dec 29 2006 3:57 PM | Permanent Link |
"Edhrx" | Tim,
I now cannot reproduce the problem. I was preparing the clients table to send across to you and decided to re-migrate it from a dbisam 4 table. I tested again and found this table dos'nt have the problem. Overall I migrated about 90+ tables from an old project. I will test a few more. Sorry if time wasted... Ed.. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:ED9177DC-8912-4C3A-8331-6139AA418C34@news.elevatesoft.com... > > << This does not > select id,surname,forenames from clients where id = :id > > #601 CLIENTS table corrupt (error reading index pages into cache) > > However, if you put a default value into the parameter property it works >> > > Could you possibly send me the table that you're using ? I can't get > anything bad to happen with parameterized queries here. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Sat, Dec 30 2006 11:31 AM | Permanent Link |
"Edhrx" | Tim
Ok, now found the table with the problem. Please find attached table. "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:ED9177DC-8912-4C3A-8331-6139AA418C34@news.elevatesoft.com... > > << This does not > select id,surname,forenames from clients where id = :id > > #601 CLIENTS table corrupt (error reading index pages into cache) > > However, if you put a default value into the parameter property it works >> > > Could you possibly send me the table that you're using ? I can't get > anything bad to happen with parameterized queries here. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > Attachments: edbtest.zip |
Tue, Jan 2 2007 2:03 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ed,
<< Ok, now found the table with the problem. Please find attached table. >> Actually, I'll need the EDB catalog and the tables. The best way to do this would be to just do a backup on the database containing the tables, and only select the tables that you want to send me. However, a new preview will be out today and there's been some format changes to the catalogs, etc. so you'll have to wait and send me the backup using the new preview. Thanks, -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |