OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Read data from fields with SQL

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
arfgh
General User
General User


Joined: 21 Feb 2010
Posts: 21

PostPosted: Sun Feb 21, 2010 9:27 am    Post subject: Read data from fields with SQL Reply with quote

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
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Sun Feb 21, 2010 10:02 am    Post subject: Reply with quote

arfgh:

You asked:

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

I have no idea what you are talking about.

Can you please give an example of what you mean?

Sliderule
Back to top
View user's profile Send private message
arfgh
General User
General User


Joined: 21 Feb 2010
Posts: 21

PostPosted: Mon Feb 22, 2010 3:18 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Sliderule
Super User
Super User


Joined: 29 May 2004
Posts: 2499
Location: 3rd Rock From The Sun

PostPosted: Mon Feb 22, 2010 7:15 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
arfgh
General User
General User


Joined: 21 Feb 2010
Posts: 21

PostPosted: Mon Feb 22, 2010 10:40 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Feb 22, 2010 2:11 pm    Post subject: Reply with quote

Hello


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


There you are new it is better to read for some weeks the post on this forum. Also it can be good to understand how to search this forum for author who already did have answer your questions. I think read posts of Villeroy and search for examples of Villeroy on a forum.

Romke
Back to top
View user's profile Send private message
arfgh
General User
General User


Joined: 21 Feb 2010
Posts: 21

PostPosted: Wed Feb 24, 2010 6:32 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group