Jump to content


Photo

Empty Rows Problem


  • Please log in to reply
3 replies to this topic

#1 Afiag

Afiag
  • Members
  • 117 posts

Posted 11 August 2006 - 10:19 PM

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 ?

#2 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

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
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.

#3 Afiag

Afiag
  • Members
  • 117 posts

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


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 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 8,191 posts
  • Gender:Male

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
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.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users