Frank S.
|
| Posted: 03/28/2005, 3:02 PM |
|
Hi Folks,
Following the tutorial for the first time and have run into a slight problem. The Data Source window only displays the one set of variables. When viewing the SQL in the Query Window, the new code shows there.
Any suggestions?
Frank
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 03/29/2005, 1:48 AM |
|
Frank,
Open Data Source dialog of a form and click on Build Query button to open Visual Query Builder. There check that flag next to fields you want to use like Control Source is checked. Or select asterisk flag (SELECT *) for a table.
_________________
Regards,
Nicole |
 |
|
Frank S.
|
| Posted: 03/29/2005, 6:30 AM |
|
Thanks, Nicole.
In addition, is the SQL code supposed to carry over to the record field from the grid?(Grid to Record).
The reason I ask is that my joins do not show in the record fields.
Any suggestions?
Thanks,
Frank
|
|
|
|
Frank S.
|
| Posted: 03/29/2005, 6:41 AM |
|
Found the way to open the Query Builder in the form but now get a message of "column 'ID' in where clause is ambiguous"
I have an "ID = {ID}" in the Data Source window.
Can you explain?
sorry about the newbie questions.
FS
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/29/2005, 5:55 PM |
|
Using queries in Record is more tricky. That's where usually listboxes are often used so in many cases there is no need for queries to be used with Records.
It can take 30 seconds to setup a Record with a query (use Custom Insert/Update/Delete), but it's possible that you just don't need it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
