G
Guest
After running the upsizing in all tables was added a field, called upsize_ts.
What can I do with this field?
Can I delete it?
Thanks,
José Perdigão
What can I do with this field?
Can I delete it?
Thanks,
José Perdigão
giorgio rancati said:Hi Jose,
It's a timestamp field, in Access Adp it's very useful in the record update
operation.
Open Profiler tool and trace the update operation for a table with timestamp
field. Repeat the update in a table without a timestamp field. You'll see
the difference
bye
--
Giorgio Rancati
[Office Access MVP]
Jose Perdigao said:After running the upsizing in all tables was added a field, called upsize_ts.
What can I do with this field?
Can I delete it?
Thanks,
José Perdigão
Jose Perdigao said:Hi Giorgio.
[CUT]Can I rename this feld (upsize_ts) and maint the useful that you said?
Another question.
Why the wizar palce dbo.[table name]? Can I remove dbo?
giorgio rancati said:Hi Jose
Jose Perdigao said:Hi Giorgio.[CUT]Can I rename this feld (upsize_ts) and maint the useful that you said?
Yes, you can rename the timestamp field, its name isn't important.
[CUT]
Another question.
Why the wizar palce dbo.[table name]? Can I remove dbo?
No, you can't remove it from database, it's a part of object name.
View this link
----
Database Owner (dbo)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_9qyh.asp
Using Identifiers as Object Names
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_03_9c8j.asp
I want use:
DoCmd.OpenStoredProcedure "nameSP", acViewNormal
When I open it, of course it comes a message to enter FDY and rDate.
I don't know how can I pass the parameters to sp.
Do you know any sites where I can find examples about ADPs?
I'm converting mdb to ADPs and I'm very glad, is much more quickly but I
must spend many time to finish this conversion
FROM dbo.A110Gas INNER JOIN
dbo.A210Gas ON dbo.A110Gas.MeterID =
dbo.A210Gas.Meter
I mean, if a use all fiels from A110Gas table and A210Gas table,and if in
both tables I have same fiels name (upsize_ts), I can't do it.
Jose Perdigao said:Hi Giorgio.
Can I rename this feld (upsize_ts) and maint the useful that you said?
I have this question because I need to make views and/or sp using the
following sintax:
SELECT dbo.A110Gas.*, dbo.A210Gas.*
FROM dbo.A110Gas INNER JOIN
dbo.A210Gas ON dbo.A110Gas.MeterID =
dbo.A210Gas.Meter
I mean, if a use all fiels from A110Gas table and A210Gas table,and if in
both tables I have same fiels name (upsize_ts), I can't do it.
Another question.
Why the wizar palce dbo.[table name]? Can I remove dbo?
Thanks a lot
José
giorgio rancati said:Hi Jose,
It's a timestamp field, in Access Adp it's very useful in the record
update
operation.
Open Profiler tool and trace the update operation for a table with
timestamp
field. Repeat the update in a table without a timestamp field. You'll see
the difference
bye
--
Giorgio Rancati
[Office Access MVP]
Jose Perdigao said:After running the upsizing in all tables was added a field, called upsize_ts.
What can I do with this field?
Can I delete it?
Thanks,
José Perdigão
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.