Re: ReplicationID

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

David,

Yes I meant stored queries of course.
Yes I would need a query that returns the type of clumns (inclusive of the
replicationID one)

I need from sql to list in a table the cols and keys and mainly the col
types as I need then to call an API to convert the binary data to readable
format

I forgot mentioning I am not working in access ....

Merci

--
Thank you

Cordialement - Best regards
Jean-Pierre GUTSATZ

CGF
32 Rue Jean Moulin
34 630 Saint-Thibéry
Tel : (33) 467 322 167
Fax : (33) 1 5301 4749

DMC - Data Management Center - A tool to let you Migrate Import Export
Transfer all your Data very easily
www.dmc-fr.com cgf@xxxxxxxxxx
Certified by Microsoft : "Works with Vista" & "Works with Windows Server
2008"

"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> a écrit dans le message de
news: Xns9AE7C9FB1841Ff99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxx
"Jean-Pierre Gutsatz \(DMC\)" <cgfjpfg@xxxxxxxxx> wrote in
news:uZjfkgw7IHA.3976@xxxxxxxxxxxxxxxxxxxx:

Would anyone know the sql syntax to use to call any access stored
procedure to retreive a list of columns WITH the type to be able
to store in a Q the ReplicationID ones ?

There are several problems with your question:

1. Access does not have stored procedures. Maybe you just mean a
stored query?

2. It's not clear what you're asking in the second part of your
question. Do you mean you want a query that tells you which columns
are of ReplicationID type? DAO makes it quite easy -- you can check
the .Type property of the field, as here:

CurrentDB.TableDefs("tblPerson").Fields("s_GUID").Type

That returns 15 (which is the value of the global constant dbGUID)
for a field of Autonumber type set to Field Size of ReplicationID. I
don't know that you can do this in SQL. I also don't know why you'd
want to do it in SQL.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/




.

Relevant Pages

  • Re: ReplicationID
    ... Yes I would need a query that returns the type of clumns ... (inclusive of the replicationID one) ... I need from sql to list in a table the cols and keys and mainly ...
    (microsoft.public.access.tablesdbdesign)
  • Re: ReplicationID
    ... to store in a Q the ReplicationID ones? ... Access does not have stored procedures. ... don't know that you can do this in SQL. ...
    (microsoft.public.access.tablesdbdesign)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)
  • Re: Store procedure vs Direct statement ???
    ... Try opening up query analyzer and checking out the query plan or ... advantages of using stored procedures over not using stored procedures is the ... the better the overall performance of your SQL ... dynamic sql versus the execution plan for a stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)