tcp-insert - Options?

[G-o-r-d]

Thanks for the work you are putting into a r3 mySQL driver. However, when I try to retrieve Table information using a SQL Query Command I'm getting an error message:

"tcp-insert does not allow char! for its options argument"

Are you able to help me with this? I don't know what 'options' it is looking for.

I'm not sure if Nenad Rakocevic's guide at http://softinnov.org/rebol/mysql-usage.html is even applicable. (I do have that working but that was for R2, not R3 and R2 isn't working on the Android, so looking for an R3 solution.) So maybe I'm even using the wrong Query command.

[zsx]

Could you give me an example of your sql query? Thanks!

[G-o-r-d]

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB: mysql://[Username:Password]@[Domain]/[DBName]
db: open Open-DB
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; Get everything from Table called Vehicle
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

[zsx]

I am on my phone, so I can't check the code, but I dont think you are supposed to call insert on the port directly, but instead you should call send-sql

Gordon Raboud notifications@github.com编写：

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB-Table: mysql://[Username:Password]@[Domain]/[Table]
db: open Open-DB-Table
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; rem At it's simplest form
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

—
Reply to this email directly or view it on GitHub.

{"@context":"http://schema.org","@type":"EmailMessage","description":"View this Issue on GitHub","action":{"@type":"ViewAction","url":"https://github.com/zsx/mysql-r3/issues/1#issuecomment-60593652","name":"View Issue"}}

[zsx]

发自我的小米手机

Gordon Raboud notifications@github.com编写：

Thanks for the quick reply, (sorry I took so long to check for a reply).
Here is the Rebol Test script:

Rebol [ Title: "Basic mySQL test"]
do %mysql-protocol.r3
Open-DB-Table: mysql://[Username:Password]@[Domain]/[Table]
db: open Open-DB-Table
; Okay so far - no apparent errors in opening it
QueryStr: "SELECT * FROM Vehicle" ; rem At it's simplest form
insert db QueryStr
; also tried: insert db QueryStr make object![] as the code seems to suggest that it is expecting an object for options.
;
Table: copy db
close db
Record: first Table
print ["Record type:" type? Record] ; = block (in R2 but errors out before it gets here in R3)

—
Reply to this email directly or view it on GitHub.

{"@context":"http://schema.org","@type":"EmailMessage","description":"View this Issue on GitHub","action":{"@type":"ViewAction","url":"https://github.com/zsx/mysql-r3/issues/1#issuecomment-60593652","name":"View Issue"}}

[G-o-r-d]

Thank-you! That was it.