Sunday, October 25, 2009

Delete Top Records with SQL - Foxpro shortcut

The easiest way to delete records (top records) in foxpro is to simply type, "delete from table_name where recno()<=4000" This doesn't work correctly if you order the table in a way other than set by its index. You could delete the index then try it, but if you just need the top X amount of records as it's ordered, and it hasn't changes, it works great!

40 comments:

週休 said...

Every why has a wherefore.........................................

有甚麼新歌 said...

Dexterity comes by experience. ....................................................

Anonymous said...

看後受益良多,謝謝∪ˍ∪........................................

Anonymous said...

若對自己誠實,日積月累,就無法對別人不忠了。........................................

Anonymous said...

初到貴寶地,拜碼頭!!!請多指教! ........................................

Anonymous said...

一個人最大的敵人常是自己。......................................................

Anonymous said...

TAHNKS FOR YOUR SHARING~~~VERY NICE.................................................

Rupe0705rtJ_Brobst said...

77p2p影片區hi5 tv 免費影片xxx383美女寫真aa一夜情台中援交妹視訊甜心寶貝直播貼片av成人網g8mm 視訊壞朋友論壇視訊美女msvt中部人聊天室視訊網愛聊天室網路援交168論壇辣妹貼圖新竹援交38ga片下載全國最大俱樂部豆豆聊天室1007視訊xvideo打飛機專用網哈尼視訊援交友aio34c蒼井空影片下載avdvd69性殿dodo豆豆聊天室色美眉部落格 2,視訊主播脫衣秀台南視訊月宮貼圖情趣 商品拓網交友-情色視訊拓網交友情色視訊免費視訊美女,情人視訊網自拍線上av免費影片線上免費av影片咆哮小老鼠專區一葉情貼影禁區kiss168一葉情貼影色影cu成人bt色站girl5320cu成人bt色片

Anonymous said...

看到好文章心情就很好 ^^ ........................................

Anonymous said...

pleasure to find such a good artical! please keep update!! ........................................

Anonymous said...

hi!~~leave you a message to say hello, and thanks for your share!........................................

Anonymous said...

999無瑪試看圖uu 視訊高雄情人援交 免費成人影片,日本美女寫真集 情色影片 亞洲禁果影城貼片 520sex免費視訊 日本av女優,免費性短片欣賞 aa免費線上85cc電影直播 免費視訊美女-殺很大 聊天室交友 淫美論壇 a383l影音城 一本道 a片 東京熱成人圖片區 情色avdvd貼片 台南援交月光論壇 UT視訊交友85cc影城 85x1x成人影院 gay壞朋友 ut正妹 聊天室 高中生援交 視訊0204movie免費影片 34c影音視訊聊天室 美女交友-免費視訊 制服妹影片 免費av18禁 080 中部人聊天室 上班族俱樂部 utobe 影片分享 sexy girl辣妹妹影音視訊 嘟嘟貼圖區av影片下載 557557視訊聊天 免費線上成人影片bonbonsex s383視訊 找援交小二館遊戲區免費av kk俱樂部 c字庫-視訊美女 免費h影片,成人影片分享 kiss 影音視訊聊天室 520sex成人視訊 本土自拍貼圖區sex hi5 tv免費影片百分百貼圖區 1007視訊聊天 sogo 色論壇,嘟嘟情人色網影片 美女交友-視訊聊天 a漫hilive tv免費電影 豆豆情色視訊aio aaa 片試看 視訊豆豆情色080 qq美美色網影片,彩虹頻道免費影片 kk69視訊俱樂部

Anonymous said...

我喜歡用心經營的blog~ ^^ ........................................

長卉長卉 said...

傻氣的人喜歡給心 雖然每次都被笑了卻得到了別人的心..................................................

Anonymous said...

Never put off till tomorrow what may be done today.............................................................

Anonymous said...

好的開始,就是成功的一半。..................................................

Anonymous said...

婚姻對男人來說是賭他的自由,對女人而言卻是賭她的幸福。..................................................................

瓊富 said...

看到大家都留言-我也忍不住說聲---加油

初蓉初蓉 said...

死亡是悲哀的,但活得不快樂更悲哀。......................................................................

毅筠毅筠 said...

一個人的價值,應該看他貢獻了什麼,而不是他取得了什麼.................................................................

Anonymous said...

It takes all kinds to make a world.............................................................

Anonymous said...

It takes all kinds to make a world.............................................................

Anonymous said...

快樂與滿足的秘訣,就在全心全意投注於現在的每一分,每一秒上..................................................

Anonymous said...

好熱鬧喔 大家踴躍的留言 讓部落格更有活力..................................................................

Anonymous said...

真有內容的部落格~..................................................................

Anonymous said...

哈囉!來拜訪囉~部落格很棒^^~..................................................................

Anonymous said...

來幫忙拼人氣~Go Go Go 時間可證明一切............................................................

Anonymous said...

實在是太完美了!非常感谢!给心心!(〃ω〃)............................................................

Anonymous said...

我在戀愛著?--------是的,因為我在等待著.................................................................

Anonymous said...

雖天地之大,萬物之多,而惟吾蜩翼之知。..................................................

Anonymous said...

凡事三思而行,跑得太快是會滑倒的。.......................................................

Anonymous said...

他能,假使他想他能;他不能,假使他想他不能。.......................................................

Anonymous said...

永遠不要躊躇伸出你的手。也永遠不要躊躇接受別人伸出的手。.................................................................

蔡曼鄭美玉屏 said...

累死了…來去看看文章轉換心情~............................................................

Anonymous said...

河水永遠是相同的,可是每一剎那又都是新的。............................................................

江仁趙雲虹昆 said...

好的部落格就要和好朋友分享--感謝分享..................................................

Anonymous said...

第一次睇你blog,鐘意!............................................................

Anonymous said...

cool blog,期待更新............................................................

Anonymous said...

要繼續發好文喔^^加油!...............................................

Software Development in Sydney Blog said...

Your post is very interested. It is very useful and helpful fro me. Thanks for share this valuable post.