Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mod free hand sql via vba ?

Status
Not open for further replies.
jjl

jjl

Programmer
Apr 23, 2001
9
US
Trying to modify free hand sql via vba ... receive error DA0011 Cannot find universe. Any hints? Thx.

Code
=====
Application.ActiveDocument.DataProviders.Item(1).SQL = "select order_item_id from ptel_po where order_item_id IN ('OI000176')"
 
Sort by date Sort by votes
It was not an editable property ... ended up using MS ADO.
 
Upvote 0 Downvote
The SQL is an editable property on my setup. Recommend you :
1. set up a standard query using the GUI, then
2. capture the SQL
3. edit the SQL as you see fit

By setting up the report conventionally, you will assure that you can connect to the universe.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Clappy2000
  • Locked
  • Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
242
Clappy2000
Clappy2000
robinshalabh12
  • Locked
  • Question
VBA for BOXI
Replies
1
Views
180
kray4660
kray4660
Vik12
  • Locked
  • Question
Edit conditions in data provider using VBA
Replies
0
Views
156
Vik12
Vik12
Spedie
  • Locked
  • Question
Rich Client 3 Tier Mode
Replies
0
Views
162
Spedie
Spedie
12silky
  • Locked
  • Question
BO SQL Performance
Replies
1
Views
74
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top