Read data from fields with SQL

arfgh · General User Joined: 21 Feb 2010 Posts: 19

Hi

i am very new with the use of the OO.
I found a way to specify parameters in a SQL command

SELECT "bla" FROM "X" WHERE "Name" = :TextBox

But i also need to know if exist a way to read the data from the current field and with SQL

THX in advance

Sliderule · Posted: Sun Feb 21, 2010 10:02 am Post subject:

arfgh:

You asked:

arfgh · General User Joined: 21 Feb 2010 Posts: 19

i mean that i want to read the content of a textbox in a form made with base. And i want to do it with a sql command.

Sliderule · Posted: Mon Feb 22, 2010 7:15 am Post subject:

Since you want to get data from a form ( what you were asking was not at all clear from your first post ) . . . after a forum search . . .

http://www.oooforum.org/forum/viewtopic.phtml?t=74097&highlight=textbox+form+sql

Perhaps others will have some advise.

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add [Solved] in your first post title ( edit button ) if your issue has been fixed / resolved.

arfgh · General User Joined: 21 Feb 2010 Posts: 19

This probably works, but... Cant be done without macros ?. I mean if can be done the same with a sql commad that i can insert in a SubForm for example.

I repeat that i am very new with the use of OO.

RPG · Posted: Mon Feb 22, 2010 2:11 pm Post subject:

Hello

arfgh · General User Joined: 21 Feb 2010 Posts: 19

I repeat the question

This probably works, but... Cant be done without macros ?. I mean if can be done the same with a sql commad that i can insert in a SubForm for example.