database - INSERT into table including foreign keys to related tables -


please if help,

i have 3 tables: 1. clients; 2 accounts; 3. transactions ...

i want clientid clientname , accountid accountname , insert id`s transactions , other values other fields known ...

clients 

clientid | clientname | ...

accounts

accountid | accountname | ...

transactions

transid | account id | clientid | value | tax | total

how can ... tried many many forms of insert statement didnt work

i tried this:

insert transactions (accountid, clientid, value) values  (select accountid accountname = 'some name'   accounts, select clientid clientname = 'some name' clients, 30.00 )

value reserved word in ms access.

i think want this:

insert transactions ( accountid, clientid, [value] ) select accounts.accountid, clients.clientid, 30.00 expr1 accounts, clients (((clients.clientname)='jimmy') , ((accounts.accountname)='mark'));

you'll need rewrite sql fit tables/table names possibly worked me.

you should make sure value double data type, not long integer. (which default number field)


Comments

Post a Comment

Popular posts from this blog

Regex find and replace between <div class="customclass"> and </div> tag -

i cant find anywhere working regex expression find , replace text between div tags so there html want select between <div class="info"> , </div> tag , replace other texts <div class="extrauserinfo"> <p>hello world! sample text</p> <javascript>.......blah blah blah etc etc </div> and replace with my custom text codes <tags> asdasd asdasdasdasdasd</tags> so <div class="extrauserinfo"> custom text codes <tags> asdasd asdasdasdasdasd</tags> </div> here refiddle code there , can see want replace whole bunch of codes between , tag http://refiddle.com/1h6j hope mean :) if there's no nesting, plain match non-greedy (lazy) (?s)<div class="extrauserinfo">.*?</div> .*? matches amount of character (as few possible) meet </div> used s modifier making dot match newlines too. edit : here javas...
Read more

jpa - Passing entitymanager from reflection method -

we using struts2, ejb jpa. @persistencecontext private entitymanager entitymanager; // here getting entitymanager reflection method m = c.getdeclaredmethod(methodname, params); //here params accept class<?> now want pass entitymanager using reflection. how pass entitymanager in getdeclaredmethod ? billy, reply. now fixed issue using transactionscopedentitymanager. we using struts2 + ejb + jpa 1.0 (cmt). have many action classes , form values persist in db. created ejb every 1 action. planing 1 ejb action classes. go reflection. using getdeclaredmethod, can pass method name , params. here params accept classes. need pass our form object , entitymanager. used entitymanager type, changed transactionscopedentitymanager.
Read more