RE: xQL Metoer SQL

["Neil Frost" <neil@xxxxxxxxxxxxx>]

Thanks Tony, Tom and Steve,
I have re written the script, and renamed the table.

I will try it out tonight and see what happens.

Cheers
Neil

________________________________

From: Tony Tofts [mailto:tony@xxxxxxx]
Sent: Mon 28/02/2005 15:26
To: ukha_xpl@xxxxxxx
Subject: RE: [ukha_xpl] xQL Metoer SQL




> call sub_writesql()

Looks fine to me

> to reomve the [] around the table name, does my line look
> like this now?
>
> strmsg=strmsg+"SQL=SELECT * FROM '"Telephone
Calls"'" & chr(10)
>
> instead of
>
> strmsg=strmsg+"SQL=SELECT * FROM [Telephone Calls]" &
chr(10)

No, it's best to call the table TelephoneCalls so the best format is:

> strmsg=strmsg+"SQL=SELECT * FROM TelephoneCalls" &
chr(10)

But if you were only seeing the first xpl message sent, more than likely
the
message being built was invalid in someway...

Regards
Tony




xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx