Cyric
Joined: 22 May 2005
Posts: 4
Location: Rome, Italy
|
 Posted: Sun May 22, 2005 14:14 Post subject: How to Store Object in Access ??? |
 |
|
I was trying to set up a persistent storage chest, anyone know how must be created in Access the table "pwobjdata" ?
I can't find the field type for the object anywhere...
_________________
Reami Perduti - Server Italiano PW |
|
Cyric
Joined: 22 May 2005
Posts: 4
Location: Rome, Italy
|
| Posted: Mon Jun 13, 2005 16:51 Post subject: |
|
|
I tried many time to use it with Access, but cannot store the data...
In the logs (odbc logs) the operation seems to be executed, but no data is stored in the database.
| Code: | o Got request (scorco): INSERT INTO pwobjdata (player,tag,name,val,expire) VALUES('Cyric the Dark','Aluvian Darkstar','Item_0',~s,0)
o Got request (scorco): SELECT val FROM pwobjdata WHERE player='Cyric the Dark' AND tag='Aluvian Darkstar' AND name='Item_0'
o Got request: DELETE FROM pwobjdata WHERE player='Cyric the Dark' AND tag='Aluvian Darkstar' AND name='Item_0'
o Got request: SELECT player FROM pwobjdata WHERE player='Cyric the Dark' AND tag='Aluvian Darkstar' AND name='Item_0'
o Empty set
|
The Database was created this way:
| Code: | | CREATE TABLE pwobjdata (player varchar(64) NOT NULL, tag varchar(64) NOT NULL ,name varchar(64) NOT NULL ,val OLEOBJECT,expire int, last timestamp NOT NULL,PRIMARY KEY (player,tag,name)) |
Any idea about why it don't works ?
_________________
Reami Perduti - Server Italiano PW |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
