Hello,
Am 26.03.2011 19:12, schrieb John Fabiani:
> I had to look -
> I did
> mycur=self.Application.getConnectionByName('pgConnection').getDaboCursor()
> mycur.execute("%s Limit 10" % (self.sqlID.Value))
> # where self.sqlID is the sql statement written in a edit box.
>
> I don't know what the poster has in mind but I'd do a quick and dirty of
> dropping the "LImit 10" and added it (the limit statement) directly to the
> actual statement written in the edit box.
>
Yes, I think that's best. If my SQL textbook is to be trusted, LIMIT is
no part of the standard, is that right?
> As I said earlier - it's just a quick tool I used to create a blank report
> form with 10 records in the testCursor. Having the data available allows the
> report designer to use real field names etc... It just made life easier when
> Larry was doing the reports for a client.
>
Exactly. I'll try it out a little more and then put it on the wiki. Not
tested with MS SQL Server and MySQL, but if the SQL statement isn't
changed by the application that shouldn't matter.
Greetings
Sibylle
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
