Andrew B
|
| Posted: 02/04/2002, 10:32 PM |
|
I would like to have the 'where' clause work with custom SQL. I am talking about the 'where' box under any form's 'sql'.
This would let me write my sql statement, and then put my where clause in where it will only be evaluated at runtime.
Since CC can not interperet asp/php/cf/blah, when I try to put a where clause in the SQL it breaks. I use custom sql quite often for this type of stuff, and almost always tie it to something like the userid. What I am forced to do is write the sql in the 'custom sql' box, and then ALSO write it in the custom code. Maintaining in two places is bAd.
|
|
|
 |
Alex Alexapolsky
|
| Posted: 02/05/2002, 4:30 AM |
|
1) You can tie db field to user id without sql. It's done through
Form Properties/Input tab by adding UserID variable and setting it's type to session.
2) CC should blend custom sql and where box. I suppose u do something the
wrong way. Give an example what is in custom sql and in where box ,
and what particular error message you get.
3) you can always tie everything up in Form/Open event by assigning
sql statement to sSql variable
|
|
|
|
andrew B
|
| Posted: 02/07/2002, 8:32 PM |
|
I am confuzed about what was confuzing me! The two do blend properly, so I assume I was using a record form. In that case, everything is as it should be.
|
|
|
|
|
