Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table or Cursor
Message
From
23/03/2009 12:06:48
 
 
To
23/03/2009 11:26:50
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01390685
Message ID:
01390720
Views:
85
This message has been marked as a message which has helped to the initial question of the thread.
>Hi All
>
>Suppose I have this situation
>
>
>use (_samples+'data\customer') in 0 Shared Alias Table1
>Create Cursor Table2 (p_name c(20))
>
>? IsTable("table1") && Return .T.
>? IsTable("table2") && Return .F.
>
>Procedure IsTable(tcTableName)
>    *** What is the function?
>Endpr
>
>
>What is the best way of telling that Table1 is "TABLE" and Table2 is "CURSOR"
(1)
IsTable = !empty(cursorgetprop('DataBase', m._alias)) and inlist(Cursorgetprop('SourceType', m._alias), DB_SRCTABLE)

(2)
IsView =  !empty(cursorgetprop('DataBase', m._alias)) and !inlist(Cursorgetprop('SourceType', m._alias), DB_SRCTABLE)

(3) otherwise
IsCursor
ps: justext(dbf()) returns TMP for both a cursor and a view
&& excerpt form foxpro.h
*-- Source Types for CursorGetProp()
#DEFINE DB_SRCLOCALVIEW         1
#DEFINE DB_SRCREMOTEVIEW        2
#DEFINE DB_SRCTABLE             3
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform