Re: Remote view but too many columns

From: Anders Altberg (x_pragma_at_telia.com)
Date: 03/19/04

  • Next message: Bharat: "Re: Old Delphi created DAT IDX files" 
    Date: Fri, 19 Mar 2004 11:50:44 +0100

    Kathy
    The names of all columns in a remote database with more than 255 columns
    will be returned with :
    ?SQLCOLUMNS(h,'tablename','native','sqlcol1')
    where h is your ODBC connection handle that you get with SQLCONNECT()
    The keyword here is 'NATIVE'. Sqlcol1 is just a name for the result cursor.

    When you've got your two cursor you can synchronize movement in cursor2 with
    cursor2 with
    SET RELATION TO RECN() INTO Cursor2 IN Cursor1
    -Anders

    "Kathy Weise" <kw@kathyweise.com> wrote in message
    news:Sgp6c.28133$%06.10022@newsread2.news.pas.earthlink.net...
    > Rick,
    > Thanks a ton!
    >
    > Kathy
    >
    >
    > "Rick Bean" <rgbean@unrealmelange-inc.com> wrote in message
    > news:Ob%23zghSDEHA.1600@tk2msftngp13.phx.gbl...
    > Kathy,
    > You'll just need to create the view in code. Create a simple view (with a
    > table that's got fewer fields<g>), then use GENDBC, to see the code that's
    > necessary to create a view from scratch. I've found this is easier than
    > figuring it out from the syntax in the Help file!
    >
    > Rick
    >
    > "Kathy Weise" <kw@kathyweise.com> wrote in message
    > news:pUj6c.27587$%06.2840@newsread2.news.pas.earthlink.net...
    > > How would I do that? I can't connect to the table to select fields and I
    > > can't alter the table.
    > >
    > >
    > > "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
    > > news:OxfuQ4PDEHA.3348@TK2MSFTNGP11.phx.gbl...
    > > > You're limited to 255 fields. You'll have to do a subset of the
    fields.
    > > >
    > > > Fred
    > > > Microsoft Visual FoxPro MVP
    > > >
    > > >
    > > > "Kathy Weise" <kw@kathyweise.com> wrote in message
    > > > news:r_i6c.27436$%06.26730@newsread2.news.pas.earthlink.net...
    > > > > I'm trying to set up a remote view to a table that has 304 fields.
    > When
    > > I
    > > > > try to add the table, it says, "Too many columns".
    > > > >
    > > > > Is there a way to do this?
    > > > >
    > > > >
    > > > > Kathy Weise
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

  • Next message: Bharat: "Re: Old Delphi created DAT IDX files"