Forums Active Threads
Print Thread
SQL Variable?
#6174 03/12/04 01:18 AM
Joined: Feb 2004
Posts: 15
J
joet Offline OP
Member
OP Offline
joet
Member
J
Joined: Feb 2004
Posts: 15
How do you reference fields returned from a Sql query. In the Example below I want to set a variable equal to the feature_id field returned
from my query. If this is not predefined how do I reference it?


SQL = Format("select feature_id from app_feature_assoc where service_no_id = %s and feature_id in (1865,1869,1870,1871,1874,1911,", OPENARRAY(TVarRec,(s)));
OracleDataSet1->Close();
OracleDataSet1->SQL->Clear();
OracleDataSet1->SQL->Add(SQL);
OracleDataSet1->Open();
Re: SQL Variable?
#6175 03/12/04 06:39 PM
Joined: Aug 1999
Posts: 22,206
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,206
The SQL doesn't seem quite right, but you can access the field(s) by name. For example:
Code
OracleDataSet1->Close();
OracleDataSet1->SQL->Clear();
OracleDataSet1->SQL->Add(SQL);
OracleDataSet1->Open();
if (!OracleDataSet1->Eof) 
  ShowMessage(OracleDataSet1->FieldByName("feature_id")->AsString);

Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.086s Queries: 13 (0.043s) Memory: 2.4966 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-28 20:35:55 UTC
Valid HTML 5 and Valid CSS