Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table File Type settings in VFP9
Message
From
06/05/2006 22:36:54
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01119850
Message ID:
01119910
Views:
19
Hi,
Added Type 67 0x43 (Varchar) at the end
CLEAR
CLOSE DATABASES ALL
lcCmd = [CREATE TABLE Testxxx ( cc C(20), mm M] + [)]
= ShowTableType(lcCmd,48)
lcCmd = [CREATE TABLE Testxxx ( cc C(20), mm M] + [, ii I AUTOINC] + [)]
= ShowTableType(lcCmd,49)
lcCmd = [CREATE TABLE Testxxx ( cc C(20), mm M, ii I AUTOINC] + [, vv v(20)] + [)]
= ShowTableType(lcCmd,50)
lcCmd = [CREATE TABLE Testxxx ( cc C(20), mm M, ii I AUTOINC] + [, qq Q(20)] + [)]
= ShowTableType(lcCmd,50)
lcCmd = [CREATE TABLE Testxxx ( cc C(20), mm M, ii I AUTOINC] + [, ww W] + [)]
= ShowTableType(lcCmd,50)
cCmd = [CREATE TABLE Testxxx ( cc V(20), mm M] + [)]
= ShowTableType(lcCmd,67) 
RETURN
*-------------------------------------------------------

FUNCTION ShowTableType(tcCmd, tnExpected)
&tcCmd
USE
lnTableType = ASC(FILETOSTR("Testxxx.dbf"))
?
? lcCmd
? "Table Type: " + TRANSFORM(lnTableType )
IF lnTableType <> tnExpected
	?? " - Expected ", TRANSFORM(tnExpected)
ENDIF	
RETURN
>
>>I have been testing Varchar, Varbinary & Blob field types in VFP9.
>>
>>One thing I have noticed is that the File type in the DBF Header is only being set to 0x32,
>>which is the setting for Auto-increment, and not 0x43 as stated in the specs.
>>
>>Is this going to cause problems, especially when you have Autoinc and say a Varchar and a Blob field in the same table and the Type set to 0x32, and not 0x43 as it should be.
Regards N Mc Donald
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform