I have a system with many tables and several with about 280 fields (please
don't ask to modify the structure, I inherited a quite large and complex
project), this is on client side, basically the code performs an initial
query to load recordsets (from tables), bounds the recordsets to table
views, allows the user to edit values, then writes modified values to
recordsets and finally calls update() to write data on tables.
I noticed that for the big (280 fields) tables the code instead to modify
directly the
edited record (by setting new values and then calling update) deletes the
record, adds a new record, writes data on the new record and finally calls
update(), a note explains
that this was done to circumvent the 255 field limit of the ADO update
query.
I would hope there is a more efficient way to solve this problem, I am not
an ADO expert but perhaps there are possibilities to control the query
originated by calling update() in order to breakdown the complexity, any
suggestions ?
ADO update and tables with more than 127 fileds ... I noticed that for the big tables the code instead to modify... edited record (by setting new values and then calling update) deletes the ... that this was done to circumvent the 255 field limit of the ADO update...query. ... (microsoft.public.vb.database)
ADO update and tables with more than 127 fileds ... I noticed that for the big tables the code instead to modify... edited record (by setting new values and then calling update) deletes the ...query. ... there are methods/variables to control the complexity of the ... (microsoft.public.data.ado)
ADO update and tables with more than 127 fileds ... I noticed that for the big tables the code instead to modify... edited record (by setting new values and then calling update) deletes the ...query. ... there are methods/variables to control the complexity of the ... (microsoft.public.vb.general.discussion)
Re: Programmatically changing the field formats for a table ... You can modify some properties of a field with SQL statements, ...Roger dot Carlson at Spectrum-Health dot Org ... > created using a query.... > the resulting table does not keep the field formats of the ... (microsoft.public.access.tablesdbdesign)
Re: webbased search through catalog ... I've got the asp script working, but it seems to spit out results ...Modify q.catalog to specify your catalog name. ... > ' your logo is not a GIF file, or you don't want to copy it, change the ... > ' You can set the number of query results returned on a single page ... (microsoft.public.inetserver.indexserver)
