Very Computer

I'm trying to 'SQL' my PDox 7 application as my database is now on Linux /
PostgreSQL.

In ObjectPAL, I'm trying to write INSERT statements (unsuccessfully)

For example I've got:

inserttxnSQL = SQL
   /*
Alias: pg
*/
INSERT INTO ~tablename ("col1","col2") VALUES ('data1', 'data2')
endSQL

But I really want to do something like:

inserttxnSQL = SQL
   /*
Alias: pg
*/
INSERT INTO ~tablename ("col1","col2") VALUES (~var1, ~var2)
endSQL

But I just get a General SQL error. What's wrong with the above?

I've been even  more unsuccessful creating the INSERT as a string and doing
a readfromString, but maybe I need to go that route? My INSERTs are big and
I quickly reach the 255 char limit for strings.

Any ideas/pointers what is the best way of doing this please?

Thanks again

Stuart

Can't help with the actual SQL, but

String 'limit' can be gotten around by concatenating smaller strings
into your final string.
st1="..."
st2="..."
stFinal=st1+st2

Or use a memo variable, then assign the memo var to a string var.
mem="..."
mem=mem+"..."
stFinal=string(mem)

--
--
 For the quickest and best Paradox support see:
 http://www.thedbcommunity.com/support/

 Tony McGuire
 http://www.thedbaddons.com
 http://www.thedbcommunity.com
 http://www.thedbcommunity.com/inet/
 http://www.thedbaddons.com/jsip/ (JSI)
"I woke up and was able to get myself out of bed.
Being that fortunate, what's to complain about?"
_____________

: Hi,
:
: I'm trying to 'SQL' my PDox 7 application as my database is now on
Linux /
: PostgreSQL.
:
: In ObjectPAL, I'm trying to write INSERT statements (unsuccessfully)
:
: For example I've got:
:
: inserttxnSQL = SQL
:    /*
: Alias: pg
: */
: INSERT INTO ~tablename ("col1","col2") VALUES ('data1', 'data2')
: endSQL
:
:
: But I really want to do something like:
:
: inserttxnSQL = SQL
:    /*
: Alias: pg
: */
: INSERT INTO ~tablename ("col1","col2") VALUES (~var1, ~var2)
: endSQL
:
:
: But I just get a General SQL error. What's wrong with the above?
:
: I've been even  more unsuccessful creating the INSERT as a string
and doing
: a readfromString, but maybe I need to go that route? My INSERTs are
big and
: I quickly reach the 255 char limit for strings.
:
: Any ideas/pointers what is the best way of doing this please?
:
: Thanks again
:
: Stuart
:
:

Try:

inserttxnSQL = SQL
/*
Alias: pg
*/
INSERT INTO ~tablename (col1,col2) VALUES ('~var1', '~var2')
endSQL

You need the quote marks around the tilde variable names so the literal SQL
expression has the proper quote delimiters.

--
Larry DiGiovanni
Digico, Inc.
IT Consulting and Staffing Solutions
www.digicoinc.com

Quote:> Hi,

> I'm trying to 'SQL' my PDox 7 application as my database is now on Linux /
> PostgreSQL.

> In ObjectPAL, I'm trying to write INSERT statements (unsuccessfully)

> For example I've got:

> inserttxnSQL = SQL
>    /*
> Alias: pg
> */
> INSERT INTO ~tablename ("col1","col2") VALUES ('data1', 'data2')
> endSQL

> But I really want to do something like:

> inserttxnSQL = SQL
>    /*
> Alias: pg
> */
> INSERT INTO ~tablename ("col1","col2") VALUES (~var1, ~var2)
> endSQL

> But I just get a General SQL error. What's wrong with the above?

> I've been even  more unsuccessful creating the INSERT as a string and
doing
> a readfromString, but maybe I need to go that route? My INSERTs are big
and
> I quickly reach the 255 char limit for strings.

> Any ideas/pointers what is the best way of doing this please?

> Thanks again

> Stuart

NoaH

Quote:> Stuart:

> Try:

> inserttxnSQL = SQL
> /*
> Alias: pg
> */
> INSERT INTO ~tablename (col1,col2) VALUES ('~var1', '~var2')
> endSQL

> You need the quote marks around the tilde variable names so the literal
SQL
> expression has the proper quote delimiters.