comp.lang.idl-pvwave archive: archive » Re: idl

Home » Public Forums » archive » Re: idl - Mysql interface

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Re: idl - Mysql interface [message #51398]

Tue, 21 November 2006 02:20

Wox
Messages: 184
Registered: August 2006

Senior Member

On Tue, 21 Nov 2006 11:12:26 +0100, Wox <nomail@hotmail.com> wrote:

> author='Brian A. Larsen'
> a=3
> v=3
> objDB->ExecuteSQL, $
> "UPDATE "+table+" SET a = "+string(a)+" WHERE v=
> "+string(v)
>
> objDB->ExecuteSQL, $
> "DELETE FROM "+table+" WHERE v1= "+string(v)
>
> objDB->ExecuteSQL, $
> "INSERT INTO "+table+"(author,v,datetime) VALUES
> ('"+author+"',"+string(v)+",CURRENT_TIMESTAMP)"

Probably better to use IDLdbRecordset in the first two cases :-).
Anyway, this is just an illustration.

Report message to a moderator

[Message index]

		Re: idl - Mysql interface By: Wox on Tue, 21 November 2006 02:20
		Re: idl - Mysql interface By: Wox on Tue, 21 November 2006 02:12
		Re: idl - Mysql interface By: Marshall Perrin on Mon, 20 November 2006 18:08
		Re: idl - Mysql interface By: henrygroe on Mon, 20 November 2006 11:55
		Re: idl - Mysql interface By: Rick Towler on Mon, 20 November 2006 09:52
		Re: idl - Mysql interface By: Brian Larsen on Wed, 29 November 2006 16:29

Previous Topic:	"free" screen size
Next Topic:	Re: Martin Shultz's MSG_GUI

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Oct 08 15:53:42 PDT 2025

Total time taken to generate the page: 0.00341 seconds