[python-win32] Re: Problems using JET SQL CREATE TABLE statement
Jorgensen, Jens
jjorgensen@Tallan.com
Wed, 17 Jul 2002 16:43:00 -0400
R2VvcmdlLA0KIA0KQWx0aG91Z2ggSSBjYW4ndCBiZSBjZXJ0YWluIEknbSBnb2luZyB0byBndWVz
cyB0aGF0IHRoZSBkaWZmZXJlbmNlcyBpbiBiZWhhdmlvciBiZXR3ZWVuIFB5dGhvbiBhbmQgVkJT
IGFyZSBvY2N1cmluZyBiZWNhdXNlIHdoZW4geW91IGFyZSBleGVjdXRpbmcgdGhlIHN0YXRlbWVu
dHMgaW4gUHl0aG9uIHRoZSBvYmplY3RzIGRvIG5vdCBnZXQgZGVsZXRlZCBhbmQgc29tZWhvdyB0
aGUgZGF0YSBpcyBub3QgYmVpbmcgd3JpdHRlbiB0aHJvdWdoIHRvIHRoZSBmaWxlLiBTb21lIG9m
IHRoZSBzY2VuYXJpb3Mgc3VwcG9ydCB0aGlzIGFuZCBvdGhlcnMgY29udHJhZGljdCBpdCBidXQg
SSBzdGlsbCBiZWxpZXZlIHRoaXMgaXMgdGhlIGNhc2UuIFNpbmNlIHRoZSBpbnRlcmZhY2UgaXMg
Q09NIHRoZSBDT00gb2JqZWN0cyB0aGVtc2VsdmVzIGRvbid0IGtub3cgaWYgcHl0aG9uIGlzIGNh
bGxpbmcgdGhlbSBvciBWQlMgaXMgYW5kIHRoZSByZXN1bHRzIHNob3VsZCBiZSBubyBkaWZmZXJl
bnQuIFRyeSBwdXR0aW5nIHlvdXIgc3RhdGVtZW50cyBpbnRvIGEgLnB5IGZpbGUgYW5kIHJ1bm5p
bmcgdGhlIHNjcmlwdHMgd2l0aCBweXRob24uZXhlIHJhdGhlbiB0aGFuIHB5dGhvbndpbi4gQW55
IGRpZmZlcmVuY2Ugb2JzZXJ2ZWQgdGhlbj8NCiANCkJUVyBJIHVzZSBBRE8gbXlzZWxmIGFuZCBt
YW5pcHVsYXRlIEpldCBkYXRhYmFzZXMgZmFpcmx5IG9mdGVuIGFuZCBhdCB0aW1lcyB1c2UgQWNj
ZXNzIGluIHRhbmRlbSBhbmQgaGF2ZW4ndCBzZWVuIGFueSBwcm9ibGVtcyBsaWtlIHRoaXMuIFlv
dSBjYW4gY3JlYXRlIG5ldyBKZXQgZGF0YWJhc2VzIHRvbywgeW91IGp1c3QgdXNlIEFET1guIEFE
T1ggYWxzbyBsZXQncyB5b3UgZ2V0IGxpc3RzIG9mIHRhYmxlcywgZXRjLg0KDQoJLS0tLS1Pcmln
aW5hbCBNZXNzYWdlLS0tLS0gDQoJRnJvbTogR2VvcmdlIFZlc3RlcmdvbSBbbWFpbHRvOnVuaWZv
YW1AdG90YWwubmV0XSANCglTZW50OiBXZWQgNy8xNy8yMDAyIDEwOjIyIEFNIA0KCVRvOiAncHl0
aG9uLXdpbjMyQHB5dGhvbi5vcmcnIA0KCUNjOiANCglTdWJqZWN0OiBbcHl0aG9uLXdpbjMyXSBS
ZTogUHJvYmxlbXMgdXNpbmcgSkVUIFNRTCBDUkVBVEUgVEFCTEUgc3RhdGVtZW50DQoJDQoJDQoN
Cg0KCTIwMDIgSnVseSAxNywgV2VkbmVzZGF5DQoJDQoJUHJvYmxlbToNCglXaGVuIHRyeWluZyB0
byB1c2UgdGhlIENSRUFURSBUQUJMRSBzdGF0ZW1lbnQgKEpFVCBTUUwpLCB0aGUgdGFibGUgaXMN
CgljcmVhdGVkIGJ1dCBkb2VzIG5vdCBzaG93IHVwIGluIHRoZSBEYXRhYmFzZSBXaW5kb3cgaW4g
QUNDRVNTLg0KCUVudW1lcmF0aW5nIHRoZSBUYWJsZURlZnMgY29sbGVjdGlvbiBpbiBQeXRob24g
c2hvd3MgdGhhdCB0aGUgdGFibGUgaGFzDQoJYmVlbg0KCWFkZGVkLCBidXQgZG9lc24ndCBzaG93
IHVwIHdoZW4gSSBydW4gQUNDRVNTLiBSZWZyZXNoaW5nIHRoZSB3aW5kb3cNCglkb2Vzbid0IGRv
IGFueXRoaW5nLiBXaGVuIHRoZSBzYW1lIHN0YXRlbWVudCBpcyBwZXJmb3JtZWQgaW4gYSBWQkEN
CglNb2R1bGUsIHRoZSB0YWJsZSBpcyBjcmVhdGVkIGFuZCBzaG93cyB1cCBpbiB0aGUgRGF0YWJh
c2UgV2luZG93Lg0KCQ0KCUFzc3VtcHRpb25zOg0KCTEuIEFDQ0VTUyAyMDAwIC8gREFPIDMuNg0K
CTIuIFB5dGhvbiAyLjINCgkzLiB3aW4zMmFsbC0xNDgNCgk0LiBNYWtlUHkgb24gIERBTyAzLjYg
T2JqZWN0IExpYnJhcnkNCgkNCglFeGFtcGxlIFNlc3Npb24gdXNpbmcgUHl0aG9ud2luIChqdXN0
IHRvIGlsbHVzdHJhdGUgd2hhdCBJJ3ZlIGRvbmUNCgk+Pj4gIyBvcGVuIGEgZGF0YWJhc2UgYW5k
IHByaW50IG91dCBvYmplY3RzLg0KCT4+PiAjIGRhdGFiYXNlIGNvbnRhaW5zIDIgdGFibGVzDQoJ
DQoJPj4+IGZyb20gd2luMzJjb20uY2xpZW50IGltcG9ydCBEaXNwYXRjaCwgY29uc3RhbnRzDQoJ
Pj4+IGRiZSA9IERpc3BhdGNoKCdEQU8uREJFbmdpbmUuMzYnKQ0KCT4+PiB3cmsgPSBkYmUuV29y
a3NwYWNlcygwKQ0KCT4+PiBkYiA9IHdyay5PcGVuRGF0YWJhc2UoJ3B5ZGIubWRiJykNCgk+Pj4g
ZGJlDQoJPHdpbjMyY29tLmdlbl9weS5NaWNyb3NvZnQgREFPIDMuNiBPYmplY3QgTGlicmFyeS5f
REJFbmdpbmU+DQoJPj4+IHdyaw0KCTx3aW4zMmNvbS5nZW5fcHkuTWljcm9zb2Z0IERBTyAzLjYg
T2JqZWN0IExpYnJhcnkuV29ya3NwYWNlPg0KCT4+PiBkYg0KCTx3aW4zMmNvbS5nZW5fcHkuTWlj
cm9zb2Z0IERBTyAzLjYgT2JqZWN0IExpYnJhcnkuRGF0YWJhc2U+DQoJDQoJPj4+ICMgZW51bWVy
YXRlIFRhYmxlRGVmcyAoc3lzdGVtIHRhYmxlcyBub3Qgc2hvd24pIHdpbGwgcHJpbnQgMiB0YWJs
ZXMNCgljdXJyZW50bHkgaW4gdGhlIGRhdGFiYXNlOg0KCT4+PiB0YmxkZWZzID0gZGIuVGFibGVE
ZWZzDQoJPj4+IGZvciB0YmwgaW4gdGJsZGVmczoNCgkgICAgICAgIHByaW50IHRibC5OYW1lDQoJ
DQoJdGJsRXgwMQ0KCXRibEV4MDINCgkNCgk+Pj4gIyBub3cgbGV0cyBjcmVhdGUgYSBuZXcgdGFi
bGUgdXNpbmcgSkVUIFNRTA0KCT4+PiB0eHRzcWwgPSAnQ1JFQVRFIFRBQkxFIHRibE5ld1RhYmxl
IChOYW1lIENIQVIoNDApLCBDaXR5IENIQVIoNDApICk7Jw0KCT4+PiBkYi5FeGVjdXRlKHR4dHNx
bCkNCgkNCglFdmVyeXRoaW5nJ3Mgb2theSBoZXJlLCB0YWJsZSBpcyBjcmVhdGVkLCBubyBwcm9i
bGVtLiBOb3cgbGV0J3MgcmVmcmVzaA0KCVRhYmxlRGVmcyBhbmQgcHJpbnQgaXQgb3V0Lg0KCQ0K
CT4+PiBkYi5UYWJsZURlZnMuUmVmcmVzaCgpDQoJPj4+IHRibGRlZnMgPSBkYi5UYWJsZURlZnMN
Cgk+Pj4gZm9yIHRibCBpbiB0YmxkZWZzOg0KCSAgICAgICAgcHJpbnQgaS5OYW1lDQoJDQoJdGJs
RXgwMQ0KCXRibEV4MDINCgl0YmxOZXdUYWJsZQ0KCQ0KCUlmIEkgc3dpdGNoIHRvIEFDQ0VTUyBh
bmQgcmVmcmVzaCB0aGUgRGF0YWJhc2UgV2luZG93LCB0YWJsZSB0YmxOZXdUYWJsZQ0KCWlzDQoJ
bm90IGluY2x1ZGVkIGluIHRoZSBsaXN0Lg0KCQ0KCUkndmUgdHJpZWQgdGhlIGZvbGxvd2luZyBz
Y2VuYXJpb3M6DQoJDQoJMS4gSWYgSSBjbG9zZSBib3RoIEFDQ0VTUyBhbmQgUHl0aG9ud2luIGFu
ZCByZS1vcGVuIHRoZSBmaWxlIHdpdGgNCglBQ0NFU1MsIHRoZSBuZXcgdGFibGUgdGJsTmV3VGFi
bGUgaXMgbm90IHNob3duLg0KCQ0KCTIuIENsb3NpbmcgQUNDRVNTIGFuZCBydW5uaW5nIFB5dGhv
bndpbjogdGFibGUgc2hvd3MgdXAgaW4gdGhlDQoJVGFibGVEZWZzIGNvbGxlY3Rpb24hDQoJDQoJ
My4gQ2xvc2luZyBQeXRob253aW4gYW5kIG9wZW5pbmcgQUNDRVNTOiBJZiBJIHVzZSB0aGUgQ1JF
QVRFIFRBQkxFIChmcm9tDQoJYWJvdmUpIGluIGEgU3ViIHByb2NlZHVyZSwgdXNpbmcgdGhlIFNB
TUUgbmFtZSwgdGhlIHRhYmxlIGlzIGNyZWF0ZWQgQU5EDQoJU0hPV1MgVVAgSU4gVEhFIERBVEFC
QVNFIFdJTkRPVyEgT25lIHdvdWxkIHRoaW5rIGFuIGVycm9yIHdvdWxkIGhhdmUNCgliZWVuIHJh
aXNlZCBhdCB0aGlzIHBvaW50Lg0KCQ0KCTQuIENsb3NpbmcgQUNDRVNTIGFuZCBvcGVuaW5nIFB5
dGhvbndpbjogSSBjYW4gYWRkIG5ldyByZWNvcmRzIHRvIHRoaXMNCgl0YWJsZSB1c2luZyB0aGUg
Zm9sbG93aW5nIEpFVCBTUUwgSU5TRVJUIHN0YXRlbWVudDoNCgkNCgk+Pj4gciA9ICdJTlNFUlQg
SU5UTyB0YmxOZXdUYWJsZSAoTmFtZSwgQ2l0eSkgVkFMVUVTICgiR2VvcmdlIiwgIlRvcm9udG8i
KTsnDQoJPj4+IGRiLkV4ZWN1dGUocikNCgkNCglhbmQgd2lsbCBzaG93IHVwIGluIFB5dGhvbi4g
Tm8gZGF0YSBpcyBzaG93biBpbiBBQ0NFU1MsIGV2ZW4gaWYgdGhlDQoJdGFibGUgd2FzIGZpcnN0
IGNyZWF0ZWQgdXNpbmcgVkJBIGluIGEgbW9kdWxlLg0KCQ0KCUl0IG1heSBub3QgYmUgdG9vIGlt
cG9ydGFudCBvZiBhIHByb2JsZW0gc2luY2UgSSBoYXZlbid0IGhhZCBhbnkgcHJvYmxlbQ0KCShz
byBmYXIpIHVzaW5nIERPQSBpbiBQeXRob24uIEkganVzdCB3YW50ZWQgdG8gZmluZCBvdXQgaWYg
SkVUIFNRTCB3b3Jrcw0KCXRoZSBzYW1lIHdheSBhbmQgYXBwYXJlbnRseSBJJ3ZlIGNvbWUgYWNy
b3NzIHRoZXNlICJ3YXJ0cyIuDQoJDQoJQW55IGlkZWFzPw0KCQ0KCUdlb3JnZSBWZXN0ZXJnb20N
CgkNCgkNCglfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXw0K
CVB5dGhvbi13aW4zMiBtYWlsaW5nIGxpc3QNCglQeXRob24td2luMzJAcHl0aG9uLm9yZw0KCWh0
dHA6Ly9tYWlsLnB5dGhvbi5vcmcvbWFpbG1hbi9saXN0aW5mby9weXRob24td2luMzINCgkNCg0K