|
More site info...
Databases | Forum profile
|
|
Forum profile page for Databases on http://www.realsoftware.com.
This report page is the aggregated overview from a single forum: Databases, located on the Message Board at http://www.realsoftware.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Databases" on the Message Board at http://www.realsoftware.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Databases:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
29
|
106
|
257
|
|
Post:
|
76
|
339
|
864
|
|
|
Databases Posting activity graph:
|
Top authors during last week:
user's latest post:
Serious Bug in RB 2009 R5 -...
Published (2009-12-02 15:24:00)
Quote: so it's not big deal as long as you use "BEGIN" and "END" Er, actually it is a big deal when you have a massive amount of existing SQL code to 'update' and check. Quote: But it looks like REAL are addressing the problem Right Tim, The RB Blog entry looks promising a 5.1 release to fix important issues with the SQLite plugin - fingers (and legs) crossed!
user's latest post:
RB Database example r5
Published (2009-12-02 17:45:00)
There are some known issues with REALSQLDatabase in r5. RS has announced a fix to be released mid-month.
user's latest post:
Serious Bug in RB 2009 R5 -...
Published (2009-12-02 14:54:00)
Autocommit gets disabled when you use "BEGIN" so it's not big deal as long as you use "BEGIN" and "END" with all your transactions.
user's latest post:
Access to Valentina
Published (2009-11-28 05:21:00)
_________________ Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed]
user's latest post:
Select returns too many records...
Published (2009-12-02 12:00:00)
If you perform a select and it returns a gazillion records, you can't display them all on a listbox as the listbox will go boom. How can you paginate the record set into groups of a more manageable size? I know you can keep the record set and do it manually, but is there some SQL magic that I might be missing?
user's latest post:
help with alter table COLUMN please
Published (2009-12-02 08:10:00)
I was going to unpick the SQL, but I did a quick search on ALTER TABLE in SQLLite, and found this: http://www.sqlite.org/lang_altertable.html "SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column , remove a column, or add or remove constraints from a table."...
user's latest post:
When is there no match for...
Published (2009-11-25 15:31:00)
What's really weird is that in about half my code, I'm using the full field names without error, abut in these, I've been getting the errors. <shrug>
user's latest post:
Help Me
Published (2009-12-01 17:16:00)
Thanks, it works. I needed that I was getting quite discouraged with my progress.
|
|
|
|
Latest active threads on Databases::
Started 4 days, 3 hours ago (2009-12-02 17:45:00)
by timhare
There are some known issues with REALSQLDatabase in r5. RS has announced a fix to be released mid-month.
Started 5 days, 8 hours ago (2009-12-01 12:04:00)
by simonjohn
Can you supply a bit more information? Quote: two databases what 'flavour' ie: MySQL, RealSQLDatabase etc. Quote: the new database has two new fields Database do not have fields, do you mean a table has 2 new fields? Quote: when I try and transfer the data How are you trying this?
Started 4 days, 11 hours ago (2009-12-02 09:33:00)
by Jym
What happens if you Begin and End the transaction you are doing? Your insert statement is the first transaction that might be open still ? I have no issues with 2009 v5 doing the same thing, but I keep all my inserts within a transaction statement
Started 4 days, 11 hours ago (2009-12-02 09:09:00)
by simonjohn
This could be very bad! Please see my post 'Serious Bug in RB 2009 R5 - Transactions?'
Started 4 days, 8 hours ago (2009-12-02 12:42:00)
by timhare
You can use LIMIT and OFFSET to walk through static data a chunk at a time, as long as you aren't adding or deleting records at the same time - that would throw your offsets off. Or you can come up with some more ingenious ways to achieve the same thing with dynamic data.
Started 4 days, 22 hours ago (2009-12-01 22:21:00)
by npalardy
Started 4 days, 10 hours ago (2009-12-02 10:06:00)
by Miklos
Okay I got it working like this: Code: Dim db as MySQLCommunityServer db = New MySQLCommunityServer db.host= "ip" db.port= 3306 db.DatabaseName= "test" db.UserName= "user" db.Password= "pas" if db.Connect then Dim i as Integer Dim rs as RecordSet rs = db.SQLSelect ( "SELECT * FROM products" ) Listbox1.DeleteAllRows while not rs.eof ...
Started 5 months, 3 weeks ago (2009-06-16 12:30:00)
by DaveS
_________________ Dave Sisemore MacPro, RB2008r3.1
Started 4 days, 12 hours ago (2009-12-02 08:10:00)
by jefftullin
I was going to unpick the SQL, but I did a quick search on ALTER TABLE in SQLLite, and found this: http://www.sqlite.org/lang_altertable.html "SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column , remove a column, or add or remove constraints ...
|
|
Hot threads for last week on Databases::
Started 4 days, 11 hours ago (2009-12-02 09:33:00)
by Jym
What happens if you Begin and End the transaction you are doing? Your insert statement is the first transaction that might be open still ? I have no issues with 2009 v5 doing the same thing, but I keep all my inserts within a transaction statement
Started 4 days, 22 hours ago (2009-12-01 22:21:00)
by npalardy
Started 5 days, 8 hours ago (2009-12-01 12:04:00)
by simonjohn
Can you supply a bit more information? Quote: two databases what 'flavour' ie: MySQL, RealSQLDatabase etc. Quote: the new database has two new fields Database do not have fields, do you mean a table has 2 new fields? Quote: when I try and transfer the data How are you trying this?
Started 5 days, 21 hours ago (2009-11-30 23:39:00)
by Dale
Check to see if rs = nil before trying the rs.edit. My guess is that the recordset is nil because you haven't quoted the result of the listbox cell. Try changing Code: sql = "select * from CDFiles where CDTitle = " + ListBox1.Cell(ListBox1.ListIndex, 2 ) to Code: sql = "select * from CDFiles where CDTitle = '" + ListBox1.Cell(ListBox1.ListIndex, 2 ) + "'" The way you...
Started 5 months, 3 weeks ago (2009-06-16 12:30:00)
by DaveS
_________________ Dave Sisemore MacPro, RB2008r3.1
Started 4 days, 11 hours ago (2009-12-02 09:09:00)
by simonjohn
This could be very bad! Please see my post 'Serious Bug in RB 2009 R5 - Transactions?'
Started 1 week, 1 day ago (2009-11-28 05:21:00)
by ruslan_zasukhin
_________________ Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed]
Started 1 week, 1 day ago (2009-11-28 05:09:00)
by ruslan_zasukhin
_________________ Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed]
Started 1 week, 1 day ago (2009-11-28 05:05:00)
by ruslan_zasukhin
_________________ Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed]
Started 1 week ago (2009-11-29 15:12:00)
by pamoxi
_________________ Pablo Schwindt RealBasic 2007R5 Windows XP SP2
|
|
Size: 105 bytes
