Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table File Type settings in VFP9
Message
De
06/05/2006 22:36:54
Neil Mc Donald
Cencom Systems P/L
The Sun, Australie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01119850
Message ID:
01119910
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform