Click here to Skip to main content
15,846,006 members
Home / Discussions / Database
   

Database

 
AnswerRe: doubt in logical schema of database Pin
Richard MacCutchan4-Jan-17 6:01
mveRichard MacCutchan4-Jan-17 6:01 
GeneralRe: doubt in logical schema of database Pin
Eddy Vluggen4-Jan-17 8:02
professionalEddy Vluggen4-Jan-17 8:02 
GeneralRe: doubt in logical schema of database Pin
Richard MacCutchan4-Jan-17 23:04
mveRichard MacCutchan4-Jan-17 23:04 
QuestionMySql - No results from query with WHERE Pin
BobbyStrain2-Jan-17 17:44
BobbyStrain2-Jan-17 17:44 
AnswerRe: MySql - No results from query with WHERE Pin
Mycroft Holmes2-Jan-17 21:45
professionalMycroft Holmes2-Jan-17 21:45 
GeneralRe: MySql - No results from query with WHERE Pin
Jörgen Andersson2-Jan-17 23:56
professionalJörgen Andersson2-Jan-17 23:56 
GeneralRe: MySql - No results from query with WHERE Pin
Mycroft Holmes3-Jan-17 11:29
professionalMycroft Holmes3-Jan-17 11:29 
AnswerRe: MySql - No results from query with WHERE Pin
Bernhard Hiller2-Jan-17 22:01
Bernhard Hiller2-Jan-17 22:01 
The differences in the SQL dialects of MS Access and MySQL can be terrible. It is best to avoid field / table names with blanks. If you insist on them, you must escape the name correctly, Access uses [name with blank] while MySQL `name with blank`.
Next, a comparison with LIKE expects a wild card. Strain does not contain a wild card, use Strain% instead - and make sure that you have data starting with that in one of the columns...
GeneralRe: MySql - No results from query with WHERE Pin
BobbyStrain3-Jan-17 5:30
BobbyStrain3-Jan-17 5:30 
QuestionDelete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx28-Dec-16 14:04
professionaljkirkerx28-Dec-16 14:04 
AnswerRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
CHill6029-Dec-16 4:59
mveCHill6029-Dec-16 4:59 
GeneralRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx29-Dec-16 8:04
professionaljkirkerx29-Dec-16 8:04 
AnswerI got this working partially, but can't figure out why I can't delete by Invoice Number Pin
jkirkerx29-Dec-16 9:07
professionaljkirkerx29-Dec-16 9:07 
GeneralI got it working, not sure it will always work Pin
jkirkerx29-Dec-16 10:23
professionaljkirkerx29-Dec-16 10:23 
QuestionUpdating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 12:32
professionaljkirkerx22-Dec-16 12:32 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 12:37
professionaljkirkerx22-Dec-16 12:37 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jschell26-Dec-16 8:17
jschell26-Dec-16 8:17 
GeneralRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx27-Dec-16 8:09
professionaljkirkerx27-Dec-16 8:09 
QuestionDrop & Recreate the DB Pin
Kevin Marois21-Dec-16 13:48
professionalKevin Marois21-Dec-16 13:48 
AnswerRe: Drop & Recreate the DB Pin
Chris Quinn21-Dec-16 23:03
Chris Quinn21-Dec-16 23:03 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 5:37
professionalKevin Marois22-Dec-16 5:37 
QuestionRe: Drop & Recreate the DB Pin
Richard MacCutchan22-Dec-16 5:59
mveRichard MacCutchan22-Dec-16 5:59 
AnswerRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 5:59
professionalKevin Marois22-Dec-16 5:59 
AnswerRe: Drop & Recreate the DB Pin
Simon_Whale22-Dec-16 6:49
Simon_Whale22-Dec-16 6:49 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 6:54
professionalKevin Marois22-Dec-16 6:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.