upsize_ts field

[Jose Perdigao]

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

 

[giorgio rancati]

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

 

[Jose Perdigao]

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é

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]

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

 

[giorgio rancati]

Hi Jose

Hi Giorgio.

Can I rename this feld (upsize_ts) and maint the useful that you said?

[CUT]

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

 

[Jose Perdigao]

Thanks a lot Giorgio.

I have one more qusetion and I think you can help without make a new post.
How can I open a sp or function with a parameter using docmd command?
for example:
The statement about the sp is:
SELECT dbo.B362WellData.*
FROM dbo.B362WellData
WHERE (dDatez BETWEEN @FDY AND @rDate)

Note @FDY and @ rDate are columns type datetime

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.
Could you help me?
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

Thanks a lot.
josé perdigão


docmd.

Hi Jose

Hi Giorgio.

Can I rename this feld (upsize_ts) and maint the useful that you said?

[CUT]

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

 

[giorgio rancati]

Hi Jose.

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.

DoCmd.OpenStoredProcedure metod hasn't parameters.
You can create a form based on the sp. Then you will can specify the input
parameters
----
Private Sub Form_Open(Cancel As Integer)

Me.InputParameters = "@FDY Datetime='2005-01-01', @rDate
Datetime='2005-01-31'"
Me.RecordSource = "nameSP"

End Sub
----

Do you know any sites where I can find examples about ADPs?

I am sorry, I don't know.
Have you saw the NorthwindCS.adp project ?
From Access menu ?-->Database Example-->NorthWind Project

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

bye

 

[Jose Perdigao]

Hi Giorgio,
Probability I explained badly. I know how I can link sp to forms as you
explain me. What I need, is open queries based in views, sp or functions from
a button in a form.

Also, I would like open queries based in sql statement.

Dim strSQL as string
strSQL=â€Select …â€
DoCmd.OpenStoredProcedure strSQL, acViewNormal

But I don't know how to pass the parameters to sp or to statement.

Thanks a lot,
Jose Perdigao

 

[giorgio rancati]

Hi Jose,

I'm sorry, you can't pass the parameters at DoCmd.OpenStoredProcedure
statement

bye

 

[david epsom dot com dot au]

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.

Yes you can. Try it and see.

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é

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]

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