Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problems with Array Field

 
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  Selecting data from two databases  
Author Message
Jr Mendonça

External


Since: Oct 23, 2003
Posts: 6



(Msg. 1) Posted: Thu Oct 23, 2003 11:46 am
Post subject: Problems with Array Field
Archived from groups: microsoft>public>vb>database>dao (more info?)

Hi;

I'm using a database called "Progress" and it have tables with array field.
Sample:

Table name: test
Fields : code integer
name char
phones(3) char
***
At the field "phones(3)" I can write 3 diferent phone numbers. As if they
were three fields.
But this is only the begin!
***
When I read this records via Visual Basic.DAO.ODBC(Driver MERANT) It's OK!
AND...
When I pass the ADDNEW command I get a error: You cannot Update. Database or
Object is Read-Only.
****
I tried to insert record on other tables with no array fields. And I got!
If you already passed to, please answer me.
Thank's lot.
Jr Mendonça.
ps.: excuse me for my english.

 >> Stay informed about: Problems with Array Field 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Test for empty field in a DAO Recordset - Can anyone help me to determine when an integer field contains nothing? It seems to be different than a null variable and I can't remember how to do this simple thing. I'm using a DAO 3.6 Recordset If the Integer field [IDNumber] is blank or empty I..

DAO 3.6 record locking - Hi, Is it possible to programmatically lock a single record in a VB application using DAO 3.6? I would like to lock users' records when they log on to the app. Later I can check if a user's record is locked to see if they are logged in or not. (I....

Fixes for VB4 or DAO 3.0 - I've got VB4 (32-bit) and it seems to use DAO 3.0. Is there a service pack for either of these that I can use? I'm having issues with DAO and > 2GB of RAM on the machine, and don't want to have to move to a newer version of VB if I can help it, just t...

Jet error - I've just started getting this error message on a seemingly random basis. 'The Microsoft Jet database engine does not recognize 'CID' as a valid field name or expression.' CID is a text field, and it is a valid column name. The line of code that..

DAO reference / Access 2007 - while using an Access 2007 .accdb file I can access the dao. object very easily. the following code in VBA works well : Function getrecordcount(strTableName As String) As Long Dim dbCurrent As DAO.Database Set db = CurrentDb Dim rstRecords A...
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]