Type: Posts; User: erickwidya
Search took 0.04 seconds.
January 11th, 2009, 10:02 PM
aargh..thanks for that info Krzemo
i never used trigger in my DB, so never run into any trouble :D..will change it to SCOPE_IDENTITY() ASAP ;)
December 17th, 2008, 07:17 PM
now the trend is move from desktop to Web app..web.config is the right file for this
right now i'm using .ini file too and it's great
December 11th, 2008, 09:15 PM
or u can used RETURN @@IDENTITY but it's for all ur scope based on the documentation
November 27th, 2008, 03:10 AM
i believe Access DB Linking is usefull when u use VBA code..
u have form in Access and it use linking DB which mean user can't see "the real DB" or u want to hide "the path to the real DB"
January 29th, 2008, 09:41 PM
i'm using Users, Banks, etc
for a while i used tbl prefix..but i ended using above for now coz it easier to read :D
check this out http://vyaskn.tripod.com/object_naming.htm
November 22nd, 2007, 07:36 PM
Does anyone can give example regarding ParentChild OO ?
ex: Manajer have direct employee like Supervisor, Supervisor have direct employee like Staff
so i can set the something like this...
November 20th, 2007, 07:57 PM
i think u can't do something like that..u'll end up searching entire network..
maybe what u ask is instead changing the DBPath inside the program, u want it to be dynamic so u don't need to...
November 12th, 2007, 10:49 PM
try this one
SELECT c.sorid, c.startdate, c.cost
FROM table2 AS c
WHERE c.startdate <= getdate() AND c.contractorid = 1
GROUP BY C.Sorid, c.startdate, c.cost
HAVING c.StartDate = (SELECT...
June 15th, 2007, 03:24 AM
agree with Thread1
if it use to populate grid it must use ClientSide cursor
in example #2 u didn't set CursorLocation so i think it's on Client as default otherwise u'll get an error
December 8th, 2006, 12:25 AM
let say i have this value in my Table1
Table1 = Date + EnteredNumber
1/Dec/2006 | 2
3/Dec/2006 | 1
5/Dec/2006 | 3
7/Dec/2006 | 2
8/Dec/2006 | 2
9/Dec/2006 | 5
November 10th, 2006, 03:45 AM
something strange with the Treeview
ok, i found some way to produce the error
say the node will have this kind
November 10th, 2006, 03:25 AM
The Treeview object, is it dynamically created ¿ -> yes..it populate with an xml file as the source..
Is the Treeview object on another form that's being disposed -> i'm not disposing any...
November 10th, 2006, 01:55 AM
i got this message when try to .Close a form in MDI environment
An unhandled exception of type 'System.ObjectDisposedException' occurred in system.windows.forms.dll
November 3rd, 2006, 07:30 PM
thx umararif but i'm afraid that's not what i mean
i already found an answer..
use DBCC CheckIndent
see BOL for further explanation
November 3rd, 2006, 03:17 AM
i have an identity column with value 1, 2, 3
if i delete the #3..the new record will inserted using 4 as the identity..
is there a way to use 3 as the identity since it's not there yet?
October 20th, 2006, 10:56 PM
i guest it need to set up the textbox to be not wider than the datagrid column..so if it reached its width, the text will wrapped it instead of make it wider..
have anyone got a solution for...
October 20th, 2006, 09:13 PM
textbox can have multiline feature..
the datagrid's column width is just dynamically changed..
October 19th, 2006, 11:11 PM
Of course text in textbox isn't wrapped up in edit mode -> are u sure? coz i've seen an example that wrapped
TextArea? can u elaborate more?
October 19th, 2006, 02:23 AM
as u all see at the attachment..
i'm at editing mode and the text of the textbox si not wrapping up hence it display beyond the Browser width (which i choose 800 x 600)
why this happened?
September 21st, 2006, 09:13 PM
well, i try using SPROC yesterday..
already try View and it can used SELECT ID FROM View_Name
gonna try Function though
need to catch up a bit now :)..thanks
September 21st, 2006, 02:55 AM
let say i have one query
and have 2nd query
September 20th, 2006, 03:29 AM
have a table parent child record something like this
Table1 = @ID + Desc + RefID
1 + Manager + 0
2 + Assistant Manager + 1
3 + Supervisor + 2
4 + Secretary + 1
so my plan is displaying...
September 18th, 2006, 01:28 AM
here is the solution i have
Dim a as new ClassA
Dim b As SqlDataReader = a.Retrieve(CInt(DescriptionList.SelectedItem.Value))
' Dimensions an array of ListItems that are...
September 17th, 2006, 10:24 PM
i can populate one using this method
'a is other Class that use Retrieve method to populate data against Database
Dim b As DataSet = a.Retrieve
DropDown.DataSource = b
September 5th, 2006, 09:52 PM
found an answer at other forum
it's in C#..
Click Here to Expand Forum to Full Width