| Author |
Clarion and Access Database
|
|
| Gallinarius 2006-02-08, 8:53 am |
| Hi,
I need example code for changing record in access database.
Thank you!
| |
| Tor-Bjarne 2006-02-08, 8:53 am |
| Hi,
Just connect (ado if you got v6.x) and use standard CW commands , browses,
forms ?
--
MVH
Tor-Bjarne Henriksen
WinVask Systems AS
"We make IT easy"
Http://www.fakturaprogram.no
Http://www.winvask.no
"Gallinarius" <gallinarius@hotmail.com> skrev i melding
news:drvmif$beq$1@ss405.t-com.hr...
> Hi,
>
> I need example code for changing record in access database.
>
> Thank you!
>
>
| |
| Gallinarius 2006-02-08, 8:53 am |
|
"Tor-Bjarne" <torNOSPAM$@vivi.no> wrote in message
news:-didnRZlS44r937eRVnzvA@telenor.com...
> Hi,
>
> Just connect (ado if you got v6.x) and use standard CW commands , browses,
> forms ?
I have Clarion 5.5, and I don't have ADO, I'm connecting to database with
ODBC and I can read and add records, but can't update
(Access:TblName.Update() shows error: Unsupported File Driver Function
(80)).
And if access table doesn't exists, I can't create it.
| |
| Leonid Chudakov 2006-02-08, 8:53 am |
| Do you have primary key defined for the access table?
"Gallinarius" <gallinarius@hotmail.com> wrote in message
news:ds1p19$334$1@ss405.t-com.hr...
>
> "Tor-Bjarne" <torNOSPAM$@vivi.no> wrote in message
> news:-didnRZlS44r937eRVnzvA@telenor.com...
>
> I have Clarion 5.5, and I don't have ADO, I'm connecting to database with
> ODBC and I can read and add records, but can't update
> (Access:TblName.Update() shows error: Unsupported File Driver Function
> (80)).
> And if access table doesn't exists, I can't create it.
>
>
| |
| Gallinarius 2006-02-08, 8:53 am |
|
"Leonid Chudakov" <chudakov@klarisoft.com> wrote in message
news:m62Ff.25277$Iw6.898771@news20.bellglobal.com...
> Do you have primary key defined for the access table?
No, but I mustn't change layout of database (I get it from PPC and I need to
put it back to PPC after change).
| |
| Brandon 2006-02-08, 8:53 am |
| You don't have to change the database. Just define a primary key in the
clarion dictionary.
"Gallinarius" <gallinarius@hotmail.com> wrote in message
news:ds70db$pgk$1@ss405.t-com.hr...
>
> "Leonid Chudakov" <chudakov@klarisoft.com> wrote in message
> news:m62Ff.25277$Iw6.898771@news20.bellglobal.com...
>
> No, but I mustn't change layout of database (I get it from PPC and I need
> to
> put it back to PPC after change).
>
>
| |
|
| You just have to add a unique key in your dictionary, without changing the
database.
Guy
> "Leonid Chudakov" <chudakov@klarisoft.com> wrote in message
> news:m62Ff.25277$Iw6.898771@news20.bellglobal.com...
>
> No, but I mustn't change layout of database (I get it from PPC and I
> need to put it back to PPC after change).
| |
| Gallinarius 2006-02-08, 8:53 am |
| Thank you for help!
|
|
|
|