salim

I am trying to design a web base system for A1 Holloway car hire, I am not sure about my Entity Relationship diagram as when I try to make the relationship between two table it never goes the way, here it is: booking_tbl ( PK booking_id, FK vehicle_reg, FK customer_id, …

Hi, I am looking for a program that when people sing, talk it will show the pattern such as graph of intonation of letters in order for someone else to follow, an example is such: Bob Marley (popular singer as an example) He sings, you can see the waves on …

Hi, I want to design a db for a small car hire, i am not sure about the entities, but this is how the system is: [COLOR="Red"][COLOR="Green"]a [B]customer[/B] (s) call to[B] book [/B]a [B]vehicle[/B] (s) on a particular [B]day[/B] (s) of the week or month to pick up at certain …

am trying to delete a record but I have this message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ProductID = , 1567'. /salem/pages/fresh_food/TMP3rfr35u5pa.ASP, line 74 I looked at the meaning but so far I can't see that …

I am trying to delete a specific colum, say ProductID = 30 from table Product_tbl now when I use server behaviour to delete, by filtering the recordset it doesn't really delete that particular ID but it goes only the next one in the row, for example: I enter 30 the …

am trying to delete a record but I have this message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ProductID = , 1567'. /salem/pages/fresh_food/TMP3rfr35u5pa.ASP, line 74 I looked at the meaning but so far I can't see that …

am trying to delete a record but I have this message: Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ProductID = , 1567'. /salem/pages/fresh_food/TMP3rfr35u5pa.ASP, line 74 I looked at the meaning but so far I can't see that …

HI all ! I have a stock control database, I want first the item sold and recorded as sold in the sale table secondly the item will be deleted from the stock table third the item wil be automatically reordered in the order table. is this possible please. I am …

I have it all set up for my satock control, I have the primary keys and foreign keys too, so in SQL how is it to update my stock control when I sell item so I could have products deleted from stock and inserted to sold_product tables please. [COLOR=sienna]tbl_Stock[/COLOR] ( …