Search results for query: *

Hi George, Yes, they both work. The second is a straightforward and the first I modified so it became a base query from which I can extract a desired result: select i_spID FROM (select i_spID, max(case When t_property = 'nmb_legs' Then i_property_val End) As nmb_legs...

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...

Hi JarlH, Thanks for the solution. I need it for SAS (they have their SQL facility) and I will think how to adopt the statement for it. Thanks again! Alex

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...

Probably you can do somethinbg like this: Dim str_SQL As String DoCmd.SetWarnings False str_SQL = "select * into tbl_new from tbl_old;" DoCmd.RunSQL (str_SQL) str_SQL = "Drop table tbl_old;" DoCmd.RunSQL (str_SQL) DoCmd.Rename "tbl_tmp_old", acTable, "tbl_new"...

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 2ffat, You are right, I need to ouput a detailed log file to see what's going on. Thanks anyway! Alex

It's Windows 2000. Well, the program is supposed to search a certain string in the files in a certain folder. It's similar to the standard Windows search facility. So if the string is found the name of the file gets written in the result text file. When I run the program from within Borland...

Hi 2ffat, Thanks for the tips. I tried to run the tdump, it indicated two files: KERNEL32.dll and USER32.dll. Now what? -- I added the files to the project (not sure this was what I needed), re-made the project but this didn't help. I also made sure the 'Use dynamic RTL' in the Linker pane...

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 TheAceMan1, Thanks for answering. The statement didn't work either, but that was my fault not posting the code. However you gave me an idea to check on RecordSource and the following line works just fine: Me.frm_result.Form.RecordSource = strSQL Another thing is that I don't have to create...

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...

PH, Thanks a lot! Alex

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...

Thanks a lot, Immo! Alex

Billpower, Beetee, Thanks for your help. I knew about the recordset way but it seemed to me a bit cumbersome to get just one value from a table. And I suspected there should have been another way. This DLookup function looks like what I was after. Thanks a lot again! Alexandre

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...

Thanks JackMH! I'll try this Alexandre

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...