Re: colon in item id to DOS directory



Jeremy:

This is a generalized problem when writing anything from within an MV dbms
to a Unix or Windows directory. There are O/S restrictions regarding what
characters can be used in the "filenames".

Google these restrictions and don't write anything to the O/S files using
those restricted characters in the filenames.

Hope this helps.

Bill

P.S. You'll have the same problems when copying MV dbms records to the O/S
for transfer purposes.

<panzerboy@xxxxxxxxx> wrote in message
news:1157326654.671778.25140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I wondered where my audit items were disappearing to then I noticed
their item-ids had a colon ":" in them and the audit file was a Q
pointer to a DOS directory.
Interesting behaviour when this happens.
You end of with a 0 byte DOS file with the file name being the itemid
before the colon.
You can still access the items in D3, though you cant select or list
them.
Deleting an item with a colon in the id of a DOS directory leaves the 0
byte file of the items id before the colon.

e.g.

Say AUDIT is a super-Q pointer to a DOS directory.
Q

C:/d3audit

I Edit an item
:ED AUDIT KILROY:WASHERE
new item
top
.I
001+ www
002+ (o o)
003+--oOO(_)OOo--
004+
top
.FI
[221] 'KILROY:WASHERE' filed.

:LIST AUDIT
Page 1 AUDIT.RS

AUDIT

KILROY

When I list the directory in Windows just the file "KILROY" shows with
0 bytes.

:select audit = 'KILROY:WASHERE'
[401] no items present.
:ED AUDIT KILROY:WASHERE
top
.P
001 www
002 (o o)
003 --oOO(_)OOo--
eoi 003
.EX
[220] 'KILROY:WASHERE' exited
:DELETE AUDIT KILROY:WASHERE
[435] Item 'KILROY:WASHERE' deleted
:LIST AUDIT
Page 1 AUDIT

AUDIT

KILROY

Again listing the directory in Windows shows the "KILROY" file 0 bytes.

I'm wondering if I'm doing any damge to NTFS with these files.
I guess D3 is assigning the space to store the files from Windows but
windows doesnt know about the file. Certainly the directory is
disconnected to the 'real' file.

Jeremy Thomson



.



Relevant Pages

  • Re: colon in item id to DOS directory
    ... Windows is simply rejecting the file update. ... Deleting an item with a colon in the id of a DOS directory leaves the 0 ... Say AUDIT is a super-Q pointer to a DOS directory. ... :LIST AUDIT ...
    (comp.databases.pick)
  • Re: colon in item id to DOS directory
    ... Windows is simply rejecting the file update. ... :ED AUDIT KILROY:WASHERE ... :LIST AUDIT ...
    (comp.databases.pick)
  • Re: colon in item id to DOS directory
    ... have a audit file for changes and you are including a TIMDATEstamp? ... Deleting an item with a colon in the id of a DOS directory leaves the 0 ... :LIST AUDIT ... Again listing the directory in Windows shows the "KILROY" file 0 bytes. ...
    (comp.databases.pick)
  • colon in item id to DOS directory
    ... Deleting an item with a colon in the id of a DOS directory leaves the 0 ... Say AUDIT is a super-Q pointer to a DOS directory. ... :LIST AUDIT ... Again listing the directory in Windows shows the "KILROY" file 0 bytes. ...
    (comp.databases.pick)
  • RE: Tracking File Modifications by User?
    ... Based on the information you provided, it should be a windows 2000 issue. ... you can enable Audit log in Event log to do so. ... locate the file or folder you want to audit. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)