|
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:
|
37
|
99
|
243
|
|
Post:
|
118
|
416
|
838
|
|
|
Databases Posting activity graph:
|
Top authors during last week:
user's latest post:
Update not working: Resolved
Published (2009-11-10 15:51:00)
Errr - isn't that what I said? Quote: I put a message box in after db.connect and it displayed, so I assume that means the database is connected Yep - you connected to the new in memory database.
user's latest post:
Where is my syntax error
Published (2009-11-06 11:32:00)
_________________ Dave Sisemore MacPro, OSX 10.5.8 RB2009r2
user's latest post:
Update not working: Resolved
Published (2009-11-10 14:53:00)
OK, I didn't read the OP closely enough, or forgot the problem upon reading your code. Note that if you pass db a nil for DatabaseFile, Connect will succeed and it will create a database in memory. This, of course, will not have your Registration table. My guess is that due to the new folder scheme, the database does not actually exist next to the exe any more.
user's latest post:
Can this SQL Query be Simplified?
Published (2009-11-05 18:25:00)
How about AND p.pickno IN (1,2,3,4,5,6,7,8,9,10) ? Code: select b.name as name, coalesce ( s.score, 'No Scores For This Guy (or whatever U want)!') as score, t.name as team_name from Brackets b, teams t , picks p left outer join stats s on b.id = s.BracketID where b.id = p.BracektID and p.teamid = t.id and...
user's latest post:
MySQL Update Problem
Published (2009-11-06 13:59:00)
_________________ Michael RealBasic Professional 2009r4 2.2 GHz Intel Core 2 Duo OS X 10.5.8
user's latest post:
replaceall - for many char
Published (2009-11-08 12:17:00)
thank you But even your solution didnt work until iv changed the regex word bundery for String begin - String End It fix other problem too Code: rg.SearchPattern = "\A" +q+ "\Z" So both code changed... everything works Thanks
user's latest post:
How to change Encoding coming...
Published (2009-11-09 09:29:00)
To see what encoding is being used use: Code: Dim s As String s = rs.Field( "firstname" ).StringValue If Not ( s.Encoding Is Nil ) Then MsgBox( s.Encoding.InternetName ) Else MsgBox( "Encoding is undefined for: " + s ) End If If its undefined and you KNOW its UTF8 Code: rs = app.hhtDB.SQLSelect( "Select * from people where id = 11" ) FirstNameField.Text =...
|
|
|
|
Latest active threads on Databases::
Started 2 days, 2 hours ago (2009-11-11 01:46:00)
by sbeach
There should be documentation and example scripts in the Clients/PHP folder within your RealSQL Server Admin folder. I don't know PHP very well (I prefer PERL) but see if these help you out and if not I can try to help clarify some of the syntax.
Started 2 days, 20 hours ago (2009-11-10 07:36:00)
by bigT
Is Registration the name of the database or the table or do the DB & table have the same name?
Started 1 week ago (2009-11-05 09:27:00)
by DaveS
Code: sql = "SELECT Transactions.*," +_ "Budget.BudAcctType " +_ "FROM Transactions " +_ "LEFT JOIN Budget " + _ "ON Budget.BudAcctName = Transactions.TransTo " +_ "WHERE Budget.BudAcctType IN ('Income', 'Expense') " + _ " and Transactions.TransLUI = '11/2009'" I think it should be this Code: sql = "SELECT Transactions.*," +_ "Budget.BudAcctType "...
Started 3 days, 19 hours ago (2009-11-09 09:21:00)
by dudleyH
Phil M wrote: If its undefined and you KNOW its UTF8 Encoding was Undefined and I used: FirstNameField.Text = DefineEncoding( rs.Field(" firstname ").StringValue, Encodings.UTF8 ) Thanks much Phil works great. I had tried nearly every conversion but the DefineEncoding, because with the gibberish I was getting back, I assumed it could not be utf8 the server was sending. Things are not ...
Started 5 days, 11 hours ago (2009-11-07 17:04:00)
by Dralion
_________________ -------------------- RB 2009r3 on winXP Sp2
Started 1 week, 3 days ago (2009-11-02 14:55:00)
by mvreade
I'm trying to write an update to a MySQL database. I basically need to replace everything between two strings in a text column. But that doesn't seem to be the problem. Even when I set the variable "r" below to something very trivial, it still doesn't update. So I think I'm forgetting something... Here is the method (btw: ConnectDB is a method in the app class that connects to the database)....
Started 1 week, 3 days ago (2009-11-02 08:56:00)
by DaveS
_________________ Dave Sisemore MacPro, OSX 10.5.8 RB2009r2
Started 1 week ago (2009-11-05 12:00:00)
by simonjohn
OK, firstly I don't quite understand your design, why do you have the tables Brackets AND Stats - there seems to be a one to one relationship here which is pointless. Maybe I'm missing something? The Left Join implies that some Brackets will not have Stats - ??? The Group By b.ID is not needed as there can only ever be one value for each Primary Key. If you were to join Brackets and Stats ...
Started 1 week, 1 day ago (2009-11-04 11:58:00)
by Ciccio83
No ideas? There are so many strange things here...i've added a mysql comunity server database. There are 20 tables. Some table is named "xxx yyy" so the name of the table is composed by two separately words with a space in the middle. I've seen that if a table has an entire name "xxxyyy" it is recognized and the columns in the table are recognized correctly too. If the name of the table is "...
|
|
Hot threads for last week on Databases::
Started 1 week ago (2009-11-05 09:27:00)
by DaveS
Code: sql = "SELECT Transactions.*," +_ "Budget.BudAcctType " +_ "FROM Transactions " +_ "LEFT JOIN Budget " + _ "ON Budget.BudAcctName = Transactions.TransTo " +_ "WHERE Budget.BudAcctType IN ('Income', 'Expense') " + _ " and Transactions.TransLUI = '11/2009'" I think it should be this Code: sql = "SELECT Transactions.*," +_ "Budget.BudAcctType "...
Started 1 week ago (2009-11-05 12:00:00)
by simonjohn
OK, firstly I don't quite understand your design, why do you have the tables Brackets AND Stats - there seems to be a one to one relationship here which is pointless. Maybe I'm missing something? The Left Join implies that some Brackets will not have Stats - ??? The Group By b.ID is not needed as there can only ever be one value for each Primary Key. If you were to join Brackets and Stats ...
Started 1 week ago (2009-11-05 09:22:00)
by Mike Bailey
Where is the code that is displaying that error? The error you are saying you get is different than the one that code displays, so it seems there is another piece of code creating problems, which is very possible now that you are using a thread. Also, I've noticed in a couple of your threads you are posting code from different parts of the application and they all connect to the database. Do ...
Started 2 days, 20 hours ago (2009-11-10 07:36:00)
by bigT
Is Registration the name of the database or the table or do the DB & table have the same name?
Started 1 week, 1 day ago (2009-11-04 15:53:00)
by timhare
How is the date formated in the database? SQL dates are YYYY-MM-DD. Anything else will give you bad values.
Started 1 week, 2 days ago (2009-11-03 23:30:00)
by timhare
The general form of your sql statement should be SELECT column FROM table WHERE ... What is the column name you want to return, and what is the table name? And is ROWID a string? Once you get a recordset, use rs.Field("columnName").StringValue to retrieve the value. Tim
Started 1 week, 2 days ago (2009-11-04 01:51:00)
by DaveS
dim sql as string ="SELECT mp3 FROM jottsMP3s WHERE ID == jottsMP3s.ID" This line will ALWAYS select the first row in your table as ID and jottsMP3s.ID are THE SAME THING First... you only need ONE equal sign and second I think you want your SQL to say this SELECT mp3 FROM jottsMP3s where jottsMP3s.ID=`"+id+"`" replace ` with single quotes
Started 1 week ago (2009-11-05 12:13:00)
by Mike Bailey
One simply way would be to just have an array of the question IDs and a pointer to which one you are on. Then when you pass, you just move to the next element in the array and show that question. You can also store this ID in another array of skipped questions so that you can revisit them later. Hope this helps.
Started 1 week, 3 days ago (2009-11-02 14:55:00)
by mvreade
I'm trying to write an update to a MySQL database. I basically need to replace everything between two strings in a text column. But that doesn't seem to be the problem. Even when I set the variable "r" below to something very trivial, it still doesn't update. So I think I'm forgetting something... Here is the method (btw: ConnectDB is a method in the app class that connects to the database)....
Started 3 days, 19 hours ago (2009-11-09 09:21:00)
by dudleyH
Phil M wrote: If its undefined and you KNOW its UTF8 Encoding was Undefined and I used: FirstNameField.Text = DefineEncoding( rs.Field(" firstname ").StringValue, Encodings.UTF8 ) Thanks much Phil works great. I had tried nearly every conversion but the DefineEncoding, because with the gibberish I was getting back, I assumed it could not be utf8 the server was sending. Things are not ...
|
|
Size: 259 bytes
