00:20.51 | *** join/#sql ville (~ville@dsl-hkigw1a84.dial.inet.fi) |
01:30.05 | *** join/#sql imperito (~imperito@132.170.35.216) [NETSPLIT VICTIM] |
01:30.05 | *** join/#sql prop_ (~prop@addr-213-216-242-68.suomi.net) [NETSPLIT VICTIM] |
01:30.05 | *** join/#sql Coolkat (~coolkat@user165.net056.fl.sprint-hsd.net) [NETSPLIT VICTIM] |
01:30.05 | *** join/#sql FaqMan (jdocbot@www.free-source.com) [NETSPLIT VICTIM] |
01:30.05 | *** mode/#sql [+bb *!*@*.reding01.pa.comcast.net *!*dah@202.20.67.*] by leguin.freenode.net |
01:31.07 | *** join/#sql MTec89 (~mtecscrip@dhcp065-025-075-055.neo.rr.com) |
01:32.57 | *** join/#sql offsidez (~syrianhac@66.198.39.25) |
01:36.27 | *** mode/#sql [+o alindeman] by ChanServ |
01:36.30 | *** mode/#sql [-bb *!*@*.reding01.pa.comcast.net *!*dah@202.20.67.*] by alindeman |
01:36.33 | *** mode/#sql [-o alindeman] by ChanServ |
01:38.52 | *** join/#sql Noodleman_laptop (~tuckerm@adsl-66-72-30-209.dsl.kntpin.ameritech.net) |
02:50.43 | *** join/#sql kittyanya (~someemail@dial-47.r08.scbuft.infoave.net) |
04:51.28 | *** join/#sql kasia (~kasia@218.H.cable.guam.net) |
04:53.09 | *** join/#sql kasia (~kasia@218.H.cable.guam.net) |
07:12.09 | *** join/#sql chickeneater (~lastlee@ip68-6-118-38.sb.sd.cox.net) |
07:41.53 | *** join/#sql Blessing (~Daeken@user160.net380.oh.sprint-hsd.net) |
07:41.58 | *** join/#sql ska-fan_ (~ska-fan@dsl-082-082-089-060.arcor-ip.net) |
08:24.22 | *** join/#sql kasia_ (~kasia@218.H.cable.guam.net) |
08:28.51 | *** join/#sql sheeda (sheeda@213-152-59-116.dsl.eclipse.net.uk) |
08:33.56 | sheeda | n e one good in access |
08:34.50 | dennisb | I think someone is |
08:36.06 | sheeda | good |
08:36.53 | sheeda | how do u set values in tables for derived attributes |
08:37.29 | sheeda | i have a payment filed. and i want to put commission in another filed.which is 4% of payment |
08:38.19 | dennisb | to make it clear, i can't help but the general answer is to ask the question directly instead of asking about asking the question. If someome knows he/she will answer |
08:39.03 | sheeda | okies |
08:39.16 | dennisb | I know "pure" sql and not much access, in fact I've never used it |
08:39.58 | dennisb | in sql if I needed a column which is always 4% of some other column I would do that with a view |
08:41.10 | sheeda | okay well general idea is the same. but in view u dont set values in talbes. do you? its just a diffirent view of information |
08:43.44 | dennisb | yes, a view is not stored (normally). In other databases there are triggers that are invoked whenever a row is changed that one can use to update a column |
08:45.37 | sheeda | not if a situation exists where i have two columns.where one is £ and other is $. u get value in £.and u have to convert to $ with todays rates.and save it data base as well automatically for every transaction |
08:46.34 | dennisb | as I said, I'm afraid I can't help you with access. I know so little about it that it's almost embarrassing |
08:47.02 | dennisb | it is possible to do these things with triggers, given that you have a table with the updated excange rates |
08:47.15 | sheeda | that is allright.just tell me how would you do in sql. |
08:47.19 | sheeda | i want to get idea |
08:48.40 | dennisb | A trigger is just a procedure that is invoked when a row is changed, the procedure gets the row as input and can alter it in any way it want. For example by looking up the exchange rate, do some calculations and change the row. The database makes sure your procedure is called whenever the row is changed |
08:49.38 | dennisb | the exact form of the procedure depens on the database and what procedure language you use I'm afraid, there are not real standard that works good between different databases. In some databases you can even write the procedure in different languages, including C |
08:49.57 | sheeda | ahhh i get some idea. |
08:50.17 | sheeda | access supports subquery and exression |
08:50.24 | sheeda | i think i can do some thing with that |
08:50.31 | sheeda | there is no channel for access as well |
08:50.35 | sheeda | :( |
08:50.45 | dennisb | whish is all fine, then you can code an insert query that does the lookup for you |
08:51.17 | dennisb | hmm, whish is nowhere nere the correct spelling :-) |
08:51.44 | dennisb | arg, more errors. I should stay away from english and just do sql |
10:50.04 | *** join/#sql sheeda (sheeda@213-152-59-116.dsl.eclipse.net.uk) |
10:50.22 | sheeda | Hmmm..... |
10:50.27 | sheeda | got disconnected |
10:50.42 | sheeda | well its not working at the moment |
10:50.56 | sheeda | i have look for expression syntaxes and then it might work |
10:52.27 | sheeda | Do u desing data base as well.i mean conceptual model before getting it to sql or any other data base |
10:52.34 | sheeda | ERD i mean |
11:03.15 | *** join/#sql JX_ (~WTFsck@toulouse.paratronic.fr) |
11:13.11 | *** join/#sql Lateralusleep (Lateralus@host-209-214-41-230.cha.bellsouth.net) |
11:47.05 | *** join/#sql wobbles (huntsman@dialup-86.55.221.203.acc05-waym-adl.comindico.com.au) |
13:41.13 | *** join/#sql ||cw (~chris@GC1.24.171.43.166.charter-stl.com) |
13:41.29 | *** part/#sql wobbles (huntsman@dialup-86.55.221.203.acc05-waym-adl.comindico.com.au) |
13:41.32 | *** join/#sql ||cw (~chris@GC1.24.171.43.166.charter-stl.com) |
14:15.21 | *** join/#sql [RainMkr] (~rainman@balrog.abacusg.com) |
14:59.10 | *** join/#sql webster (~nick@170.251.221.12) |
15:20.54 | *** join/#sql dennisb (~dennis@as2-4-3.an.g.bonet.se) |
15:31.17 | *** join/#sql micklweiss_work (~chatzilla@216.199.228.149) |
16:00.35 | *** join/#sql wcstok (strtok_r@dialup-67.31.178.92.Dial1.Denver1.Level3.net) |
16:02.29 | micklweiss_work | it says in the topic "this channel is not dead" |
16:02.43 | micklweiss_work | why don't i believe that... :) |
16:05.58 | webster | hehehe |
16:06.05 | webster | all depends who's on |
16:06.32 | webster | that, or everyone's hard at work and not checking the channel |
16:26.25 | *** join/#sql _terr1 (terr1@50C59405.flatrate.dk) |
17:51.24 | *** join/#sql Back2Basics (~Back2Basi@216.224.238.210) |
18:06.50 | *** join/#sql micklweiss_work_ (~chatzilla@216.199.228.149) |
18:23.17 | *** join/#sql micklweiss_work_ (~chatzilla@216.199.228.149) |
18:33.27 | *** join/#sql Manuel_B (~hallo@pD9E8221C.dip.t-dialin.net) |
18:33.45 | Manuel_B | does sybase checks automaticly for foreign key contructs? |
18:33.58 | Manuel_B | so foreign key problems? |
19:11.34 | Back2Basics | can I ask something where lines < 7 (about aggregate functions) |
19:15.08 | Back2Basics | select soldprice from main where soldagent="bsmith" and where convert(datetime,solddate) > '2000-1-1' and convert(datetime,solddate) < '2000-12-31' group by soldagent |
19:15.23 | Back2Basics | OK I made it fit into one... |
19:16.10 | Back2Basics | but this statment is invalid (in sql server) because the solddate is not included in an aggrate function or the group by clause. |
19:17.44 | Back2Basics | I don't want more than one row back (this is a sub select) and I don't realy care to include the solddate in the group by clause because then it would give me more than one row back. |
19:18.01 | ||cw | if it's not in teh group by it has to be in a sum or a max or something |
19:18.26 | ||cw | maybe you want an order by? |
19:19.04 | *** join/#sql [mage] (~mage@213-193-169-45.adsl.easynet.be) |
19:20.41 | Back2Basics | is there a way I can return an avg and then toss the value away (not have it show up) |
19:23.52 | ska-fan_ | show up where? |
19:25.14 | ||cw | it can return anything, you don't have to pull it from the RS |
19:39.08 | Back2Basics | i'm starting to think sql server sucks. |
20:20.03 | *** join/#sql MTec89 (~mtecscrip@dhcp065-025-075-055.neo.rr.com) |
20:24.44 | *** join/#sql Lateralus (Lateralus@host-209-215-8-214.cha.bellsouth.net) |
20:40.26 | *** join/#sql Manuel_B (Manuel_B@port-212-202-155-189.reverse.qsc.de) |
20:40.46 | Manuel_B | how can i edit a column where a foreign key depens appears in sybase? |
20:42.34 | *** join/#sql mick_w (~chatzilla@216.199.228.149) |
20:43.46 | *** join/#sql kittyanya (~someemail@207.144.97.91) |
20:49.37 | *** join/#sql Death_Fang (~someemail@dial-84.r02.scbuft.infoave.net) |
21:05.28 | *** join/#sql kittyanya (~someemail@dial-104.r02.scbuft.infoave.net) |
21:11.58 | *** join/#sql [mage]_ (~mage@212-100-173-43.adsl.easynet.be) |