Search results for query: *

Hello, I need to sum the values of several columns but want to avoid the $1+$2+$3...+$100 syntax. I tried the command below, but apparently I'm doing something wrong. $ cat infile 1 2 3 4 5 6 wanted result 6 15 $ awk -F "\t" '{x=0; for (i=1; i<=NF; i++); x = x + $i...

Is there a way (SQL or client command) to get the date of creation of a column in a table?

Hello. When I use rake bd:migrate, it sends this: C:\testror\depot>rake db:migrate --trace c:/ruby/bin/rake.bat:24: undefined method `require_gem' for main:Object (NoMetho dError) Any clue?

Is there a way to declare and initialise a variable on a form that retains its value even when that form is closed and reopened ?

Is there a way to call from a first form (form1) a procedure written on a second form (form2)?

I have a menu form (form1) and 2 subforms (subform1 & 2). When I update data in subform1, I want to disable subform2. I tried from subform1 Private Sub field1_AfterUpdate() Forms![subform2].Disable End Sub but VBA keeps telling me that he is unable to find that name. Any ideas?

Every time I try the following command: DoCmd.TransferText acExportDelim, "format_w_tab_header", "query123", "C:\aaa",-1 VBA tells me "Execution error 3027: update impossible, database or object is read-only." Still, the "query123" object is not a read-only one. Any clues? Thanks!

Suppose I have the 'abc' table: individual year size 1_4_5 1 112 1_4_5 2 123 1_4_5 3 146 1_4_5 4 157 2_8_3 1 92 2_8_3 2 104 2_8_3 3 98 ... I want to pivot the table to get: individual size_yr1 size_yr2 size_yr3 ... 1_4_5...

I'm a beginner in Ruby on Rails. I need to build a web interface over an already-existing PostgreSQL database. Thus, when I create models, I don't use migration to create tables. However, I need to name the models in concordance to Rails rules, that is model name (eg. 'provider') is the...

I have the following table: id group item qty 1 fruits banana 2 2 fruits orange 3 3 fruits grape 5 4 b+c bread 10 5 b+c noodles 12 6 meat eggs 7 The following SQL statement: SELECT food_list.group, Count(food_list.item) AS nb_items, Avg(food_list.qty) AS avg_qty FROM food_list GROUP BY...

I have the following fields: Column1 Column2 1005 1 1005 2 1005 3 1005 4 1010 1 1010 2 1003 1 1203 2 1203 3 1203 4 ... Is there a way to have Column2 automatically generated, that is, an incremented number that resets to 1 for every changing...

Hello, I'd like to have a SELECT statement which also creates a calculated column based on the value of a field of the preceding record. Example: Column1 Column2 Calc1 1 North - 2 West North 3 South West 4 East South 5 Other East ... I...

I can't export to Excel anymore than 255 caracters for a memo type field. In the online help for Access, they talk about this problem, but do not suggest any way to solve it. Has anybody been able to do that? Thanks,