Search results for query: *

Hello dear SQL experts, I am working on a project related to arthropod species identification. Here is a simplified table where we list various arthropod species with their properties: i_spID t_property t_species i_property_val 1 nmb_legs Blatta germanica 6 1 nmb_wings Blatta germanica...

Hello there! I am trying to import some data from a CSV file into an existing table in MySql database using phpMyAdmin. I’ve created and saved a CSV file GU_t_rf_imgTp.csv, here it is: Now in phpMyAdmin I do: first, I choose the table which to fill (in this case “GU_t_rf_img_type”). Then I...

Hello everybody, I need to join two tables.The first table has the patient ID and dates of some test. t1 ID Dt1 1 05-jan-2010 1 14-mar-2011 2 02-feb-2009 2 17-jan-2010 The second has dates of some other test with a few additional parameters. t2 ID Dt2 Param1 Param2 1...

Hi Everybody, I have the Office 2002 (Win.XP). A strange thing is happening today in Excel and Word. When I work in a workbook or in a word document some words appear by itself, especially if I don't hit keys for a while. Not just a set of unrelated characters but real words, ex. 'The', 'and'...

Hi everybody! I've written a simple console application in Borland-C++Builder-3. It works fine from inside the Borland environment, but when I try to run it separately it gives me a weird result... Any clue? Thanks, Alexandre

Hi everybody, Here is what I have. My simple db contains just one table. I've created a form with a subform. The subform is based on a SELECT query and simply shows the table contents. The main form has a few combo boxes from which a user can choose select criteria to filter data rows for the...

Hi everyone, Here is a problem. I've started using a newly installed Office-2000 and my Access VBA gives me error messages if I try to use ADO components, for example, such a message comes for the following declaration line: Dim rs As New ADODB.Recordset It tells that this is a user defined...

Hi everybody, I am wondering if there is a way to get a value from a table via SELECT statement and assign it to a variable in a VBA sub. For example, in Oracle it is possible to do the following: SELECT SomeField INTO VarName WHERE... Can anyone help with something similar for Access VBA...

Hi everybody, I need to build a complex chart, for this I want at first to create some painted area and then to put a map over it. The map is an image, which consists basically of black lines for state borders, main rivers and lakes on the white background. What I need is to put just these...

Hi everybody, I just started learning Java and installed IBM Eclipse Platform. I have a usual for beginners problem: I can't run a simpliest console program. Here it is: public class cl1 { public static void main(String[] args) { System.out.println("Hello World!"); }...

Hi everybody, Can anyone give me a link to a good STL manual? Thanks Alexandre

Hi everybody, Say, I have two tables t1 and t2: Table t1: f1 f2 --------- a 7 c 3 d 6 e 7 Table t2: f1 f3 --------- a 5 b 2 d 1 f 3 I need to join the tables in a way to produce the following result table (matching rows by f1 field): f1 f2 f3 ------------ a 7 5 b . 2 c 3 . d 6 1 e 7 . f...

Hi everybody, I am trying to work with dynamic cursors, so I wrote the following procedure (simplified version): PROCEDURE p1 AS TYPE TYPE_tbl_cursor IS REF cursor; cur1 TYPE_tbl_cursor; TYPE TYPE_row_cur1 IS RECORD ( Smplno...

Hi everybody, My cursor takes data from a many-column table and I need to process the fields in similar ways. Say, I have a table t1 with fields f0,f1,f2,f3,f4. Values of fields f1 and f3 are set, of fields f2,f4 are not. Field f0 is the primary key. Here is a snippet from the simplified...

Hi everybody, In one of my procedures I output some info for a debugging purpose. Here is the line: DBMS_OUTPUT.put_line(my_msg); 'my_msg' is of VARCHAR2 type, it is assigned not more than 6 bytes at a time. The line is used in a loop about 350 iterations. When I run the proc in...

Hi everybody, I am trying to update a table with values from another table. Here is a simplified scenario of what I wanna do: Table t1: fld1 fld2 --------- a 5 b c 3 d e 7 f Table t2: fld1 fld2 --------- b 2 d 1 f 3 I need to transfer values of t2.fld2 to corresponding...

Hi everybody, I know how to get a value from a table through opening a recordset, but I am wondering if there is another way, something like this: My_var = SELECT column1 from some_table where column2='ABC' providing that this SELECT returns a single value. ??????? Thanks, Alexandre

Hi everybody, Newbie questions. I created a stored procedure which reads data from a text file and populates a table with new records using INSERT INTO statement. The procedure works OK when called from within SQL*Plus environment. Now I want to make a form called for the same job - loading...

Hi everybody, I have a PL/SQL procedure which reads values from a text file. Each read value (either string or numeric) first comes into a temporary VARCHAR2 variable named tmpValue. Some numeric values in the file can be -99 (meaning missing) which in the database should be assigned NULL. So...

Hi everybody, More stupid questions from a newbie. My simple form has a button to pick up a file name (with the GET_FILE_NAME built-in) and a text item (TXB_FTOLOAD) where I want to display the chosen file name. I played with Set_Item_Property and Display_Item without much of success. Here is...