generate sql command in mysqldatasource

generate sql command in mysqldatasource

Postby RJordan » Fri 25 May 2007 11:33

MySqlDataTable privides a feature to automatic generate update, insert an delete commands with paramters. Is this feature available in MySqlDataSource? If yes, please advise how to do so.

Is there an example available to see, how a myqsldatasource works with a datagrid using sql commands with parameters?

Thanks for your help.
RJordan
 
Posts: 14
Joined: Tue 07 Nov 2006 11:45
Location: Germany

Postby Alexey » Tue 29 May 2007 06:31

When configuring MySqlDataSource add WHERE clause to your select command pressing "WHERE..." button. Then press "Advanced..." button and tick appropriate checkbox.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby RJordan » Wed 13 Jun 2007 18:59

Sorry, but the appropriate checkboxes are disabled und cannot be selected.
RJordan
 
Posts: 14
Joined: Tue 07 Nov 2006 11:45
Location: Germany

Postby Alexey » Thu 14 Jun 2007 12:34

Please provide me with screenshots and your table definition.
Are you using the latest version of MySQLDirect .NET?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL