473,320 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

column-OicAdmin-does-not-belong to table

when im trying to save my data I get an error
column-OicAdmin-does-not-belong to table


Expand|Select|Wrap|Line Numbers
  1. Case "btnSave"
  2.                 If RequiredField(dtDate) = False Then Exit Sub
  3.                 Mode = Mode.LoadRecord
  4.                 If gMobile.Text = "New Record" Then
  5.                     dt = ExecuteQuery("select isnull(max(nIdentity), 0) as nIdentity from inventory")
  6.                     txtTransNo.Text = Str(Now.Year).Substring(3, 2) & Format(Now.Month, "0#") & "-" & Format(dt.Rows(0).Item(0) + 1, "00000#")
  7.                     If Existing("inventory", "cTranNo", Trim(txtTransNo.Text)) = True Then Exit Sub
  8.                     drHeader = dtHeader.NewRow
  9.                     drHeader.Item("cTranNo") = Trim(txtTransNo.Text)
  10.                     drHeader.Item("cRemarks") = Trim(txtRemarks.Text)
  11.  
  12.                     If dtDate.Text = "" Then drHeader.Item("dDate") = DBNull.Value Else drHeader.Item("dDate") = dtDate.Value
  13.                     drHeader.Item("nTotal") = lblTotal.Text
  14.                     drHeader.Item("nScanned") = lblScanned.Text
  15.                     drHeader.Item("nNotScanned") = lblNotScanned.Text
  16.                     drHeader.Item("nCorrect") = lblCorrect.Text
  17.                     drHeader.Item("nException") = lblException.Text
  18.                     drHeader.Item("cPreparedByCode") = usercode
  19.                     drHeader.Item("cPreparedByName") = username
  20.                     drHeader.Item("cAccOfficerCode") = Trim(txtCustodianCode.Text)
  21.                     drHeader.Item("cAccOfficerName") = Trim(txtCustodianName.Text)
  22.                     drHeader.Item("cAccOfficerPosition") = Trim(txtPosition.Text)
  23.                     drHeader.Item("cEncoder") = Trim(txtEncoder.Text)
  24.                     drHeader.Item("cSupplyOfficer") = Trim(txtSupplyOfficer.Text)
  25.                     drHeader.Item("cTeamLeader") = Trim(txtTeamLeader.Text)
  26.                     drHeader.Item("cObserver") = Trim(txtObserver.Text)
  27.                     drHeader.Item("cMis") = Trim(txtMis.Text)
  28.                     drHeader.Item("cGenAccounting") = Trim(txtGenAccounting.Text)
  29.                     drHeader.Item("cApprovedby") = Trim(txtApprovedby.Text)
  30.                     drHeader.Item("cType") = Trim(txtType.Text)
  31.                     drHeader.Item("cOicAdmin") = Trim(txOicAdmin.Text)<-------------error here
  32.                         dtHeader.Rows.Add(drHeader)
  33.                         Call AuditTrail(Trim(txtTransNo.Text), "Created")
  34.                         Do While dtAll.DefaultView.Count - 1 >= 0
  35.                             dtAll.DefaultView.Item(0).Row("cTranNo") = Trim(txtTransNo.Text)
  36.                         Loop
  37.                         Do While dtCorrect.DefaultView.Count - 1 >= 0
  38.                             dtCorrect.DefaultView.Item(0).Row("cTranNo") = Trim(txtTransNo.Text)
  39.                         Loop
  40.                         Do While dtException.DefaultView.Count - 1 >= 0
  41.                             dtException.DefaultView.Item(0).Row("cTranNo") = Trim(txtTransNo.Text)
  42.                         Loop
  43.                         Do While dtNotScanned.DefaultView.Count - 1 >= 0
  44.                             dtNotScanned.DefaultView.Item(0).Row("cTranNo") = Trim(txtTransNo.Text)
  45.                         Loop
Oct 30 '15 #1
0 1121

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Gaz | last post by:
Hi, I need to have a table nested within another table. The tables are alongside each other visually speaking, and the nested table (on the right) can vary in size. My problem is that when the...
61
by: Toby Austin | last post by:
I'm trying to replace <table>s with <div>s as much as possible. However, I can't figure out how to do the following… <table> <tr> <td valign="top" width="100%">some data that will...
3
by: Terrence Brannon | last post by:
I don't know what Postgres considers a relation and had no intention of creating one when piping my schema to it... I always DROP TABLE before CREATE TABLE, so here are the ERRORS emitted when...
4
by: maricel | last post by:
I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY
4
by: Simone Battagliero | last post by:
I wrote a program which inserts and finds elements in an hash table. Each element of the table is a dinamic list, which holds all elements having the same hash value (calculated by an int...
117
by: phil-news-nospam | last post by:
Is there really any advantage to using DIV elements with float style properies, vs. the old method of TABLE and TR and TD? I'm finding that by using DIV, it still involves the same number of...
76
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
5
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums...
1
by: TanjaPetro | last post by:
Good Day to everyone. A few pages on my site are not displaying properly and I believe the tables in the template are at fault. I have looked at the pages with Firebug and searched the files with...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.