Search results for query: *

Hi guys, I would like to know if there is a way to create a user interface in Access. I just need a simple UI, where I can prompt the user to enter some data. Thanks for your help. AH

Hi, Assume we have the following: CREATE TABLE test1 ( id integer, content varchar ); & CREATE INDEX test1_id_index ON test1 (id); CREATE INDEX test1_content_index ON test1 (content); Which Select statement would perfom better? 1) SELECT content FROM test1 WHERE id = constant; 2)...

Hi guys, I have a general question.who is more perfomanant: Passing data by Referencing or by data Field. When I was asked this question, I answered that passing data by referencing is better or faster since here you are accessing the memory directly to perform your action, whether it is a read...

Hi, I would like to know if there is an optimum number of indexes that can be used with the Select or if not, is there a way to find out (by column, by table). Thanks for your help. ASH

Hi, I would like to know if there is an optimum number of indexes that can be used with the Select or if not, is there a way to find out. Thanks for your help. ASH

Hi all, I have this stored procedure and I want it to produce the results to GROUP BY Style1, Style2, StyleColor, Whrse_No, Bin_No ...... This procedure is used by a crystal report file to produce a report.... Below is the code: ( I think that the problem is in that some fields which are not...

Hi Guys, I have this rpt file and I was wondering how do u edit the file. I want some of the fields to get the value from anoth location ( i.e I want to change the location)....Could it be done form the report or it is always done from another function or so.. Thx alot

Hi Guys, I have this rpt file and I was wondering how do u edit the file. I want some of the fields to get the value from anoth location ( i.e I want to change the location)....Could it be done form the report or it is always done from another function or so.. Thx alot

strSQL = "SELECT setting_value FROM _setting WHERE Setting_Name = 'Interface_Installed'

Hi Guys, It is the first time I use ADO and I cannot really understand how the batch size in this code is being calculated....A brief description would really be helpful. <% dim nBatchSize strSQL = "SELECT setting_value FROM _setting WHERE Setting_Name = 'Interface_Installed'" SET...

Hi Guys, I am a new programmer and I was given a code to fix....I just would like to know what does this portion of code do (i.e the write flag part): Description: Exports Style info to flat file. CREATE PROCEDURE dbo.msp_EIExportStyleCornell @intSessionNo int , @intType int --...