Re: Is there a maximum size to a Python program?

On Apr 27, 3:31 pm, "Paul Hemans" <dar...@xxxxxxxxxxx> wrote:
Thanks John, I understand where you are coming from and will try and digest
it all. One problem though that I didn't mention in my original posting was
that the replication may only require updating one or more fields, that is a
problem with a generating a single SQL statement to cover all requests.

OK so you need TWO programs -- one tailored for initial loading of a
table, the other for subsequent updates. Still O(1) :-)

OR you could still do it in one, by using the prepared whole-row SQL
statement if appropriate, or building an SQL statement on the fly if
it's an update.

I am
having a look at eval and exec

WRONG WAY
GO BACK

to see if they will give me a little more
flexibility in runtime generation of the code.

And another thing that you didn't mention was that you are using
SQLAlchemy -- perhaps you might like to ask your question on that
package's forum ... including a few more facts than heretofore :-)

HTH
John
.

Relevant Pages

  • Re: Update Query and Timestamp
    ... It seems there is nothing wrong in your SQL statement itself, ... Public Sub Foo() ... Why are my other fields not updating? ... UPDATE query to a SELECT query, ...
    (microsoft.public.access.queries)
  • Re: Subform within Subform on Main Form data refresh
    ... When you say that you're updating the subform's query... ... Setting it directly to an SQL statement? ... > subform is still not updating with the new data. ...
    (microsoft.public.access.formscoding)
  • Re: Writing a Table with Many Fields
    ... to write the code and implement for batch inserts or updates. ... If you're updating or inserting a single row just use a Command object w/Parameters to hold your ... You can use either a SQL statement or stored procedure with this scenario. ... it's mostly a single row. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL statement question
    ... I am updating a table using the following SQL statement: ... They are both text data types. ... are supposed to be two digits. ...
    (microsoft.public.access.formscoding)