Database Help (Beginner)

[Todd Jeffreys]

I'm just learning how to use SQL. I'm using a DAODatabase which i create. Everything works great, but I have some question on Table limits. I create tables, and some of them require large text fields ( roughly 4k) When i create them, i get an error the field is too large (seems good enough). I've searched the documentation but can't seem to find limits on the fields, what is the limit? I've failed with > 512 and sometimes with > 255 depending on how many text fields I have. Thanks!

[ric]

As you work with CDaoDatabase I suppose that you create MS Access files. The field of type TEXT in the Access cannot go over 255 bytes. So for your problem go and see the Access reference and field types.

[Todd Jeffreys]

Thanks for the response. Now i've switched to CDatabase (since i don't want that 255 character limit). There is no Create member, so how can i create a brand new database? Thanks!

[nordyj]

You can use Access Databases, with CDaoDatabase, if you set the field type to Memo. I think Memo fields can store up to 64k of text.

[ric]

Use CreateDatabase() function of the CDatabase class. As far as I remember there was such a thing.