I just research the sqlite3! i dont know the way to connect database - it's maked by sqlite - to C++ project! Could you help me create a example, please? Thanks so much everybody!
hi all
i am using eclipse plug-in for developing blackberry application, i want to use database in my program
i am not getting a proper tutorial or any stuff for configuring Ultralitej with eclipse plug-in. can any one please provide me with any tutorial or any guidance.
Thanks a lot
Hi
In LINQ to SQL, you can override SubmitChanges and use the method this.GetChangeSet() to get all the inserts, updates and deletes so that you can make last minute changes before it is committed to the database.
Can this be done in EF 4.0? I see there is a override for SaveChanges but I need to know the equivalent for GetChangeSet()
Hi,
I am looking for a free/cheap SQLite editor that can handle BLOB type for Mac OS X. Basically, I just need to create a database that contains images, then load it to an iPhone app bundle. No need for fancy queries. Could someone recommend the best editor available out there for this purpose?
Thanks a lot
Team,
Can you please help me to understand why I m getting the following exception.
05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1
Thanks in advance,
Oracle 9i has nested tables, however it doesn't have the all_nested_table_cols sysview (like 10g and 11g) which lets me see what the columns are for these nested tables. How can I find this information on a 9i database?
Hi ,
in my database i have phone numbers with country code , which look somthing like
0044-123456
0044-123456
0014-123456
0014-123456
0024-123456
0024-123456
0034-123456
0044-123456
0044-123456
0024-123456
0034-123456
084-123456
084-123456
i want to total up the numbers by country, something like this output
0044 (2)
0024 (2)
0034 (1)
084 (2)
064 (5)
Is it possible to do this with a SQL query?
I'm working on a first symfony project, i am using the sfWidgetFormTextareaTinyMCE widget for a form tinymce text area. It works fine, but while retrieving from database, instead of showing me the formated text, i have the <strong>,<p>,<br>tags in the text. help me please
Hi,
I have devloped an application which connects the database thrugh WCF + LINQ. I am able invoke the service from my asp.net application successfuly. But the problem here is that, when i navigate from end to end in my application almost after four or five clicks, i am getting the late response and says channel timed out error.
If anyone is aware about the soltion for this. It would be really helpful for me.
Thanks,
If I want to save a linked instance as null in a database, what should I do?
I cannot simply pass null to obj.setOneToOneAssociatedObject(null)
Still, I want to save this link as null (table allows it).
I need to backup automatically daily my database in mysql and all image files on the server.
Is there a way to backup these things and send it on my email address ?
I want to perform a 'SELECT' statement with a byte array (binary) parameter as a condition.
I tried to google it, but didn't find anything useful.
In general, I keep information of files in the database. one of the properties is the file's hash (binary).
I want to give a hash to the SELECT statement, and get all rows with the same hash value.
I'm converting database from Teradata to SqlServer. I've noticed all tables and procedures are named by the prefix "dbo." (e.g. "dbo.Table1").
I would like to know if and how I can get rid of "dbo" because it would make the conversion task a lot more easier.
how to to implement multithreading where
one thread updating UI
and other one is reading the database record
in windows application
Any guidelines really appreciated...
Hi.I created app that searches via blue tooth mac addresses and compare match them with data base. But I want to try not matching Mac Addresses , I want to make it like taking photo and matching with in database. For this what should I do? Where to start? I have an DB that includes all value for students with an Mac addresses I thing instead of Mac addresses I will add only photos.But Matching Two photo is hard way?It don`t have to be like FBI using :)
Hello, in my web page a user fill a form who send information to a MySql database. One of the data inputs sent is a date/time, in the format date('l jS \of F Y h:i:s A');
(I can change the format as needed)
So when the user submits the form i wanna check if the actual time/date is 30 seconds more than the sent time/date in order to allow or not the submission of the form. Thanks!
How do I drop selected tables in Rails? I want to drop all tables from a database with a given prefix. PHPMyAdmin would be very useful at this point.
Thanks
I am getting a SqlConnection does not support parallel transactions. exception and this answer mentions its when a connection tries to open two transactions. This is exactly what i am doing. I thought nested transactions were ok (i was using sqlite for the prototype).
How do i check if the connection is already in a transaction? I am using Microsoft SQL Server Database File.
Hi everybody,
What's the most appropriate (read least data consuming) data field to store a true/false/1/0 value in a mySQL database?
I have previously used a one character long tinyint, but I am not sure if it's the best solution?
Thanks!
Hi, I am trying to create a trigger for a cinema database.
I need it to update once a rating is added for a movie showing the text "rating added". The table name is
movie_ratings
the primary key is = movie_rating
I am not really sure how to do it, I have looked online but still are not too sure. I was wondering if anyone could help.
Thanks
I want to cut the svn/cvs recods in pieces and then put in to database. After that i can make use of those data easily.
Any java function can get out the record? and How?
If possible, please provide a example. Thank you.
I'm interested in finding the most precise decimal values in a database field. I'd like to be able to sort results by descending precision. Is this possible?
e.g.
10.1781253
12345.12435
89.763
1.1
2