Tagged Questions

A database is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If it is about a particular database management system, like MySQL for instance, please use that tag instead.

learn more… | top users | synonyms (3)

0
votes
0answers
3 views

How to enable soundex() in iOS SQLite for a searching query?

Is there a way to use SQLite soundex() in iOS apps? Please guide me to find a way... Tried Homegrew but it works on terminal and I need to run soundex everytime in terminal. Also i dont know how to ...
0
votes
1answer
14 views

Data transfering format

I need to download onto my devices some data in multiple files. Then this data will be copied to application's local db (this is SQLite db, however in future this may be Compact SQL on WInPhone). ...
0
votes
1answer
8 views

Interchanging of database servers

Hello I am still newbie for database deployment. Generally how are changes to production database are deployed while a release? My client wants an entire new setup. We have 3 environmetns DEV INT ...
0
votes
1answer
8 views

What is the best way to alias class and method names

Here's my situation. I have a database with string data. I'm implementing tokens which essentially are "class.method" format to implement dynamic data generation. For example a column's data might ...
0
votes
1answer
9 views

“Validation Rule” in MS Access for a string column for having only numeric digits

Is it possible to have a "Validation Rule" in MS Access for a column of text/string data type that allows only numeric digits? And a "Validation Rule" that allows only alphabets?
0
votes
0answers
16 views

Updating a Database View in Android

I have a device which as a view in the Contacts database (Contacts2.db). This device is running ICS. I want to add a column to this view. So where can I find the scripts/code where these views are ...
4
votes
1answer
51 views

Execute more or complicated SQL queries, or use PHP to filter data?

I'm building a PHP app which will get a lot of traffic. I have always learned that I should limit the number of SQL queries (right now it's about 15 per visitor). I could limit this to about half, ...
1
vote
1answer
19 views

how to start xampp in windows safe mode

i can't startup my windows (maybe virus) and i can't start xampp on it i can just startup using safe mode how can i start xampp in safe mode? i need my databases backup how can i backup my ...
0
votes
1answer
20 views

Connecting to a Cache (InterSystems) Database using Java

I'm currently creating an android application and need to connect to a InterSystems cache (ODBC) database, this is the first time I have developed for android and have never connected to a database in ...
-2
votes
0answers
6 views

Access file not opening.Error Messag you and another user are attempting to change the same data at same time

Access file not opening. Error Message: The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at same time. it is not repairing ...
0
votes
0answers
6 views

Creating Database Drivers for Windows

I want to create a database driver in Windows to provide a support for custom database in Visio for forward and reverse engineering. I found that by default it has Generic OLE DB Provider IBM DB2 ...
0
votes
0answers
19 views

Allowing Multiple Connection to project with local Database ? VB

I've just build my first solution of my project that consist of a Local .mdf database & forms. However when i tried to access from different computers in a local network, only one is able to run ...
0
votes
1answer
14 views

SQLite alter table with result from select statement

I am trying to execute this statement in mozilla sqlite add-on alter table (select tbl_name from sqlite_master where rowid=1) add GUID varchar But this runs into error : SQLiteManager: Likely ...
0
votes
1answer
13 views

API design versioning with multiple databases

Should one setup versioning for API databases as he does for API URLs? API starts from api.domain.com/v1/ and eventually evolves to api.domain.com/v2/. Is it good practice to setup separate ...
0
votes
1answer
14 views

Call a method on successful transaction in EJB 2.0

I have been working with ejb 2.0 for past 2 years on my application and suddenly stuck with a problem where I just want to call a method before and after transaction to database. I am sure EJB 3.0 ...

1 2 3 4 5 … 3828
15 30 50 per page