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 Chriss Miller 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
Joined
Apr 23, 2001
Messages
9
Location
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
Is it an editable property in the first place ?
 
Upvote 0 Downvote
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 Question
Date Prompt in Freehand SQL excluding the Time (Web Rich Client Report)
Replies
0
Views
867
Clappy2000
Clappy2000
robinshalabh12
  • Locked
  • Question Question
VBA for BOXI
Replies
1
Views
694
kray4660
kray4660
Vik12
  • Locked
  • Question Question
Edit conditions in data provider using VBA
Replies
0
Views
587
Vik12
Vik12
Spedie
  • Locked
  • Question Question
Rich Client 3 Tier Mode
Replies
0
Views
645
Spedie
Spedie
12silky
  • Locked
  • Question Question
BO SQL Performance
Replies
1
Views
287
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top