Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: purplehaze1
  • Order by date
  1. purplehaze1

    how to handle null values in SQL query

    how to handle null values while doing insert/update? here's my problem, the following SQL fails: INSERT INTO t_customer (cust_cde, cust_name, m_ind, start_dte, lst_upd_id) VALUES (,'Tata Young','','2/4/2005','sResh12') db design: cust_cde is smallint type in db that allows null. cust_ind...
  2. purplehaze1

    help needed with SQL

    Is it required to have quotes around field values while doing insert/update/delete? e.g. INSERT INTO t_customer (cust_cde, cust_name, m_ind, start_dte, lst_upd_id) VALUES ('452','Tata Young','S','2/4/2005','sResh12') I receive following err msg if there's no quotes around field values (in this...
  3. purplehaze1

    how to re-write this update code

    I can't get commandbuilder to generate insert/update/delete command in Sybase, so I want to write my own update logic. But I want to avoid writing update/insert/delete routine for each table. I've got about 40 tables. Is there a way for doing this? Thanx. Public function SaveCustomer() as...
  4. purplehaze1

    getting error: Incorrect syntax near the keyword 'DEFAULT'

    Since above commandbuilder update (insert/delete/update) won't work in my Sybase db, how can u write your own update logic? Thanx.
  5. purplehaze1

    getting error: Incorrect syntax near the keyword 'DEFAULT'

    I am trying to update a record in customer table located in sybase database. I use commandbuilder. I get following error msg. How can I fix it? It works in SQL Server. Thanx. ERROR [HY00] [INTERSOLV][ODBC SQL Server driver][SQL Server] Incorrect syntax near the keyword 'DEFAULT'. commandText...
  6. purplehaze1

    Getting err: Incorrect syntax near the keyword 'DEFAULT'

    I am trying to update a record in customer table located in sybase database. I use commandbuilder. I get following error msg. How can I fix it? It works in SQL Server. Thanx. ERROR [HY00] [INTERSOLV][ODBC SQL Server driver][SQL Server] Incorrect syntax near the keyword 'DEFAULT'. commandText...
  7. purplehaze1

    how to re-write this code

    Got the items showing on the checklistbox working this way: Private Sub populateInsuranceType() Dim InsuranceTypes As InsuranceTypes InsuranceTypes = oInsuranceType.loadInsuranceType InsuranceTypeList.Items.Clear() 'checklist For Each InsuranceType as insuranceType In...
  8. purplehaze1

    how to re-write this code

    You guys are great. Like Steve said, I populated collection from the db and iterated through it to populate the checklistbox like korach suggested. However checklistbox displays all items as ProgramName.InsuranceType rather than insurance type names. What am I missing here? Thanks again. 'User...
  9. purplehaze1

    how to re-write this code

    Thanks korach and stevexff for your valuable comments. listcheckbox is good idea, didn't realize. :) Like steve said, I have insurance types in the database. And insurance class has enum type insurancetypes with the same value as in the database. Following korach's eg in the form load event...
  10. purplehaze1

    how to re-write this code

    A customer can have multiple insurances. So in user interface, I have 4 checkboxes representing multiple insurance types. If any box is checked, first I see if the checked insurance type already exists in the collection before I create a new one. The following code works but is rather long when...
  11. purplehaze1

    urgent: how to cascade foreign key to child tables

    I need to know how to cascade identity key from parent table down to child tables. I have been doing it one way but almost all articles I've read suggest using datarelation to cascade identity key. However, in my code, I save one table a time (see below) and I am confused about how to create...
  12. purplehaze1

    need help cascading identity key to child tables

    Here's the SavePatient routine that uses customer id as foreign key. Any suggestions how I can create data relation b/w here and cascade customer id to patient table? Thanks. 'client opatient.SavePatient() ' Patient class Public Function SavePatient(Optional ByVal bolStartTran...
  13. purplehaze1

    need help cascading identity key to child tables

    I need to know how to cascade identity key from parent table down to child tables. I have been doing one way but most articles I've read suggest using datarelation to cascade identity key. However, in my code, I save one table a time (see below) and so I am confused about how to create relation...
  14. purplehaze1

    urgent help needed with transactions

    Beck, I cannot instantiate oledbtransaction because it shows error when I try to. I guess the reason it's bombing is because in da.UpdateCommand.Transaction = Trans da.InsertCommand.Transaction = Trans da.DeleteCommand.Transaction = Trans da.updatecommand, da.insertcommand and...
  15. purplehaze1

    urgent help needed with transactions

    when I mouse over da.UpdateCommand, it shows nothing. What could be the reason? Thanks
  16. purplehaze1

    urgent help needed with transactions

    It blows up at line da.UpdateCommand.Transaction = Trans Error msg is "object reference not set to an instance.."
  17. purplehaze1

    urgent help needed with transactions

    I am using dataAdapter to update records (add/delete/update). I want to use transactions with dataAdapter to do updates. I am not sure how I can do it using dataAdapter. I have following coded, is it going to work to insert/delete/update records to the database? Public Function...
  18. purplehaze1

    ques abt collection and datagrid tablestyle

    I am binding the collection to a Datagrid. I can bind to the collection successfully. I am using a tablestyle to limit the data the datagrid displays. However, the tablestyle don't work. How can I make tablestyle to work for collections? another ques, what's the mapping name to be given for...
  19. purplehaze1

    formatting datagrid with data from collection

    I am binding datagrid to collection (orequests) to display customer requests. How do you format datagrid which has collection as datasource? what mapping name to use? i.e. oRequests.GetType.Name did not work. Currently, even though I want only selected fields contaied in collection objects to...
  20. purplehaze1

    ques abt collection

    Suppose I have two tables: customers and orders. I created two class, customer and orders. tbl customer ----------- custid custname tbl orders ---------- orderid custid orderName orderAmt I want to display customer orders in datagrid. So, I created orders collection and binded...

Part and Inventory Search

Back
Top