Hi Adam,
Don't you need to be referencing dbo.M2M_Booker, not just dbo.Booker?
Brant
||
Cutting down what I've found / been showed I get:
set safety off
close all
LOCAL connectionString
connectionString = "Driver={SQL
Server};Server=sageserver;Database=APAC;Uid=admin-account;Pwd=admin-pwd;"
LOCAL sql
** sql8 = "SELECT * from dbo.BOOKER"
sql8 = "SELECT * from dbo.SLCustomerAccount"
connHandle = SQLSTRINGCONNECT(connectionString)
= SQLSETPROP(connHandle, 'asynchronous', .f.)
= SQLEXEC(connHandle, sql8, 'MYTABLE')
= SQLDISCONNECT(connHandle)
Select MYTABLE
Browse
Where it's a table it works perfectly... when I reverse the comments to my
now renamed view dbo.BOOKER it falls over on the select MYTABLE with alias
MYTABLE not found...
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
