Martin Schreiber wrote:
Aha, now I see the typo, sorry it was a long day.
> Ehem, please read my answer from yesterday:
> "
> tmsesqlquery is designed for scrollable resultsets. For SQL statements
> which don't return data tsqlresult should be used.
which don't return d
On Saturday 31 December 2011 15.51:20 Patrick wrote:
> .
>
> > tsqlstatement <> tsqlresult. Use tsqlstatement for queries which don't
> > return a result, use tsqlresult for queries which return a resultset but
> > don't need to be scrollable, use tmsesqlquery if the resultset must be
> > scrollabl
.
> >
> tsqlstatement <> tsqlresult. Use tsqlstatement for queries which don't return
> a result, use tsqlresult for queries which return a resultset but don't need
> to be scrollable, use tmsesqlquery if the resultset must be scrollable.
>
Finally, a clear and concise statement as to how / whe
Looking at the source code for msesqlresult I see that "execute" is a protected
method.
Is ite meant to be "public"?
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT
On Saturday 31 December 2011 14.56:14 Patrick wrote:
> > Set the parameter values then call tsqlstatement.execute().
>
> Using a sqlresult named rsltmessage I tried
>
> rsltmessage.sql.execute();
>
> and got this error:
>
> main.pas(1463,7) Error: identifier idents no member "execute"
>
> I assumed
On Saturday 31 December 2011 14.56:14 Patrick wrote:
> > Set the parameter values then call tsqlstatement.execute().
>
> Using a sqlresult named rsltmessage I tried
>
> rsltmessage.sql.execute();
>
> and got this error:
>
> main.pas(1463,7) Error: identifier idents no member "execute"
>
> I assumed
> Set the parameter values then call tsqlstatement.execute().
>
Using a sqlresult named rsltmessage I tried
rsltmessage.sql.execute();
and got this error:
main.pas(1463,7) Error: identifier idents no member "execute"
I assumed that is what you meant by tsqlstatement.execute().
But, trying r
On Saturday 31 December 2011 00.31:33 Patrick wrote:
> > Set .sql to
> > "
> > insert into messages (touserid, fromuserid, created, message,
> > replytomessageid)
> > values (:touserid, :fromuserid, :created, :message, :replytomessageid);
> > "
>
> So after I set the sql statement of the sqlresult
On Saturday 31 December 2011 00.16:38 Patrick wrote:
> I will try the sqlresult component.
>
> Can the params.count field be manipulated in program code? If so, how?
>
>
AFAIK not directly. Please use .AddParam(), CreateParam()
RemoveParam.
Martin
---
> Set .sql to
> "
> insert into messages (touserid, fromuserid, created, message,
> replytomessageid)
> values (:touserid, :fromuserid, :created, :message, :replytomessageid);
> "
So after I set the sql statement of the sqlresult component, how do I execute
it?
Do I set active := true;
Or do
I will try the sqlresult component.
Can the params.count field be manipulated in program code? If so, how?
--
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resource
On Friday 30 December 2011 21:02:28 Patrick wrote:
> Getting closer.
>
> The following statement works with a postgressql database with the params
> fields set.
>
> Insert into messages (touserid, fromuserid, created, message,
>replytomessageid) values ($1, $2, $3, $4, $5);
>
> But this does no
Getting closer.
The following statement works with a postgressql database with the params fields
set.
Insert into messages (touserid, fromuserid, created, message,
replytomessageid) values ($1, $2, $3, $4, $5);
But this does not work with a mysql database.
Insert into messages (touserid, fr
On Friday 30 December 2011 19:14:59 Patrick wrote:
> I am learning how to use a postgresql database. I can read / write the
> database via sql statements.
>
> I would like to use a tmsesqlquery that has parameters. So far I have not
> had any success.
>
> Is there an example somewhere of what I n
I am learning how to use a postgresql database. I can read / write the database
via sql statements.
I would like to use a tmsesqlquery that has parameters. So far I have not had
any success.
Is there an example somewhere of what I need to construct / do to successfully
use a parametized query.
15 matches
Mail list logo