I have field name "Category" and its is number data type. Why I cannot store zero value in the table, I want to store the value like this 0001 but it store the value in the "category" field as '1' .Why?
HelloI have an app that takes info from a word table and puts it into a DB. I have a problem that is creating a high stress environment for me. 1. I have a field that the data type is date, with required = no. The problem comes if the word table field is blank. This gives me a "" and I get a typ...
I am using zencart style countries table in my project such as for countries in address book etc. When refer the country, I used the coutries_id such as in my address book programming.Here is the question, when I dealing with the special cases such as if the countries is usa or canada, due to i...
Hi people, I noticed the followin news messages on WinInformant:Yukon Beta Launch Q1 2003 (http://www.wininformant.com/Articles/Index.cfm?ArticleID=27529) http://www.wininformant.com/inc/images/WinInfo/sql_server_logo_sm.gif A quote from this new Message:Microsoft will deliver Yukon Beta 1 to ju...
Hi.I just had some fun trying to build a MySQL query that will return birthdays for the 7 coming days including today... I cared about New Year... I'd just like to know what you think of it...SELECT p84ue.user_id, p84ue.Anniversaire, IF(month(anniversaire) = 1 AND month(NOW()) = 12, INSERT...
Database & Application Miscellaneous New questions
whenenver I try 2 zip up my db(.mdf) file , it givz an error. I can't even copy it to another folder.Do I uncheck the archive in the file properties ?...
What could cause an mdb to have 0% compression when zipped. I import all the tables into a new mdb and get 90% compression when zipped. THe following thread might describe better:http://www.vbforums.com/showthread.php?s=&threadid=195699THanks for any help!...
Does anyone have an Access table with City, State and Zip Codes that I could bum off ya? Need one to include in my donor mailing list program for my church.Thanks,Rev. Michael L. Burns...
I want to create a database of office locations that can be searched based on zip codes. Does anyone know where I can get zip code and/or longitude/latitude data, and how to process it....
Where can I obtain, a listing of city/town, state and Zip codes for the US?Is it available for download and in an excel format or a dbase format?Thank youLeonard...
what does the function ZEROFILL do?I got a int(10) field that is unsigned in a mysql table... when i make the field zerofill - it adds 0... eg. 1 becomes 0000000001Is that the only function it has?Thanks!...
Can any one tell me how to save 'Nothing' to a Date field in a recordset.Senario;A date has been saved to a Date Field, thus changing the field from Null. The date is then not needed and deleted from the corresponding textbox object bound to the field. If I leave the textbox empty I ge...
I am using VB6 accessing as SQL Server 2000 Database.In my VB app I convert my dates to longs and store themin the SQL Server DB.I thas now come to attention that the zero date in VB6 is 30/12/1899, but in SQL Server 2000 it is 01/01/1900.Is there a way to set the zero date in VB6 so that it mat...
I am checking out the zen-cart.In zen-cart, I can set up it with English, German, and French etc.But the countries table is in English only.So if I am in French interface, the drop down menu for the countries is still in English.I am not intending to use zen-cart in my project, but I would like...
Database & Application Miscellaneous Related Categories