SQL Database Integration

Re: SQL Database Integration

Abhishek — Thu, 18 May 2006 13:48:36 GMT

Hi Nukkumatti,
U r right.
When u create a dataconnection,finally u will see a checkbox called "Automatically retreive data when the form is opened".
Unchecking it will enable u to prevent data retreival onload.
Regards,
Abhishek

Re: SQL Database Integration

nukkumatti — Thu, 18 May 2006 11:04:28 GMT

Okay I found a workaround, I just hide the repeating table as long as the two fields aren't filled and the qurey ran.
But still if someone has a better way please let my know.

Hmm or do I just have to disable the automatically retrieve data checkbox

Re: SQL Database Integration

nukkumatti — Thu, 18 May 2006 08:18:20 GMT

Okay the query works in the onclick event now i just need to know how to avoid loading data into the repeating table when the form loads.

SQL Database Integration

nukkumatti — Thu, 18 May 2006 07:22:17 GMT

Ok Guys,

I started working on a new project (C# code) with Sql database integration.
I have a secondary datasource (sql) and have a repeating table within my form. The problem is that when loading the form directly all rows from the database are shown in the repeating table. What I want to have is that the query starts running not befor two fields are filled which represent the where clause of the query. Does someone have any idea how to do that. The query should start running after a button gets clicked or through an OnAfterChange event of one of the textboxes.

Thx