Sorry, forgot the calling mechanism.
Say I built some sql string, cause I had to -
like - lcSql = [whole bunch o stuff here]
then I'd set it up for...
lcSql = sqlCheck(lcSql)
then
=sqlexec(lnHandle,lcSql, [cursResults])
Regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net
"Gene Wirchenko" <genew@[EMAIL PROTECTED]
> wrote in message
news:iicin31t2aic7isc7q62dsjds5vofa7agl@[EMAIL PROTECTED]
> "swdev2" <wsanders@[EMAIL PROTECTED]
> wrote:
>
> >I take a different approach.
> >I programmatically build SQL Select statements,
> >and run each piece of it (select, into, where, join, etc)
> >through a sql pre-processor util that i built some time ago.
> >
> >i have different flavours of it now, for native vfp, ms-sql, mySql,
> >postGreSql and oracle.
> >i think the first iteration of it - i built it in about 2 months of
spare
> >time fiddling.
> >
> >you may want to take a hard look at making yer own sql pre-processor
util.
>
> Details, please?
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
|
