Hello
I have a problem I normally don't have, used berg software a lot before so don't know why really ..... anyway when I do a sql statement and the result is empty it gives me a error "Grid Index Out Of Range"
I'm not trying to do any code after the sql is run on the empty grid.... it happens already if I put a nextdbgrid on a empty form and conect it to a adoquery with the sql:
select * from mytable WHERE DATE = ''' + datetimetostr(NxDatePicker1.Date) + '''';
or any sql that gives me no results....
How can I fix this ?
Empty Rows Problem
Started by Afiag, Aug 11 2006 10:19 PM
3 replies to this topic
#1
Posted 11 August 2006 - 10:19 PM
#2
Posted 12 August 2006 - 03:41 AM
Hello Afiag,
Can you please tell me which version of NextDBGrid you are using?
I have made one test now again and all work fine. I have connect grid to one empty table (without any record) and after I connect it, I get columns created and no rows (as expected)
If you want, I may create one small demo project and send it to you.
Thank you.
regards
Can you please tell me which version of NextDBGrid you are using?
I have made one test now again and all work fine. I have connect grid to one empty table (without any record) and after I connect it, I get columns created and no rows (as expected)
If you want, I may create one small demo project and send it to you.
Thank you.
regards
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
#3
Posted 17 August 2006 - 10:02 PM
QUOTE (Boki (Berg) @ Aug 12 2006, 04:41 AM) <{POST_SNAPBACK}>
Hello Afiag,
Can you please tell me which version of NextDBGrid you are using?
I have made one test now again and all work fine. I have connect grid to one empty table (without any record) and after I connect it, I get columns created and no rows (as expected)
If you want, I may create one small demo project and send it to you.
Thank you.
regards
Can you please tell me which version of NextDBGrid you are using?
I have made one test now again and all work fine. I have connect grid to one empty table (without any record) and after I connect it, I get columns created and no rows (as expected)
If you want, I may create one small demo project and send it to you.
Thank you.
regards
The latest I think (3.9)... I don't know why it happens either, I used dbgrids a LOT before in various other projects, this is a new project, don't understand it really ...
#4
Posted 17 August 2006 - 11:12 PM
Hello Afiag,
Can you please send me one small demo to me. Please put in zip file both source and exe.
I will send you new version via email then (i have already made some work for v3.9.1)
Thank you
Can you please send me one small demo to me. Please put in zip file both source and exe.
I will send you new version via email then (i have already made some work for v3.9.1)
Thank you
boki@bergsoft.net | LinkedIn Profile
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
--
BergSoft Home Page: www.bergsoft.net
Users Section: users.bergsoft.net
Articles and Tutorials: help.bergsoft.net (Developers Network)
--
BergSoft Facebook page
--
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users