Search results for query: *

Hey there, I got a table which has around 2 millions inserts each day (which means more than 20 inserts each second). Also, this table has a timestamp field. What will happen to this query? Will it run endlessly? SELECT COUNT(*) FROM my_table WHERE TS_FIELD > '2016-02-01 00:00:00.000000'...

Hi, Thanks for the links but, nothing is matching what I'm looking for. But, I found a way to get the information from the macros. It's probably not the most optimal but that's the only solution I got. Sub cmdSEARCH_Click() Dim cnxLocal As ADODB.Connection Dim rstForm As ADODB.Recordset...

Hey there, I have a form that search for a string I enter in all the forms/modules, the queries and the reports in my Access database. It returns me the name of the Access objects in which the string has been found. So, I can see where a certain field name or table name or query is used...

Hi, I just wanna know if it is possible include a parameter or variable to a query. The code below is not functional (and not useful at all... lol), it's just to give you the general idea behind my question. CREATE OR REPLACE FUNCTION Func_Test(P_STRING as VARCHAR2) RETURN INTEGER As V_Cnt...

Since I normally code in VB, C, C#, I never encountered such errors. (And I don't have to sum such numbers either) But, now that I know this, I'll use the round() formula more often, for sure! Thanks a lot for the link!

No, I don't know anything about those errors... I thought Excel was precise enough. For the results I displayed, I just added a space between the thousands to be more clear. The results are : 25769600833,56 and -25769600833,56. The formula : =sum(F6:F1431) The sums of the two halves were just...

Hi, I got a list of over 1400 amounts being between -500 000 000,00 and 500 000 000,00. The cells are in number format. I wanna do a sum of those amounts. And I already know I should get an answer of zero. But Excel gives me this answer : -0,0000373721122741699. In fact, if I do a sum on the...

Hello, Thanks for all your ideas. Since I have many queries in many worksheets, it's easier (and faster) for me to use the column deletion at the end of all the queries. Still, it's strange to have a delete method and we're unable to use it. Anyway, my worksheets now display well. Thanks...

Hi, Thanks for your answers. To Skip : Let me define the work I gotta do with my field AFTER getting it. IF NOT isnull(rst.Fields(2).Value) AND isnull(rst.Fields(4).Value) Then rst.Fields(4).Value = rst.Fields(0).Value Else If NOT isnull(rst.Fields(4).Value) AND NOT...

Hi, I got an Excel 2003 worksheet that I want to fill with data from Oracle. My query is on 5 fields, I want to display 4 of them but, the fifth one is only for some work and calculations that updates the recordset. I don't want the fifth field to be displayed. So, I want to hide, remove or...

Thanks, I'll try this link tonight... I probably expressed myself wrong. I don't have three computers on my network, only two. I meant : The router is connected to the cable modem AND two computers are connected to the router. Sorry!

Hi, First, both PCs have Windows XP Pro. Here's my situation : I got 2 PC connected to a D-Link router and this one is connected to my cable modem. The PCs have no problem to access to the Internet. Also, both have shared folders. The PC "A" "sees" all its shared folders AND the shared...

Hi, I would like to know what is 'behind' the rnd function. I mean the law that is used to get randomized numbers. I'm using the randomize function before the rnd and I know how to use them... but what is the code for rnd function?? Must I really trust this function? Is it based on a...

Hi, I need some help about creating text files. I use Windows 98 and I want to create text files in different directories. These directories are &quot;under&quot; the program directory. I was thinking doing this way : #include <stdio.h> #define N 300 void main(void) { FILE *fp; /*...