Updating Sort Order on a field?

-

hi

i have customer table. displaying them in sorted order. have added 1 field call sortid.
now when ever if add new entry ...i want sort , want assign sorted that.

ex:

aaaa > 1
bbb > 2
ccc > 3

if add aaa1 ..then sort has become 2 , goes one....

how update this...using , update command....

thx in adv.

what doing sortid field can't whatever field contains aaaa, aaa1, etc?


More discussions in Database Access


adobe

Comments

Post a Comment

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

-
¿conocéis este proyecto? fvdw-sl 15.3 para raspberry pi. convierte la raspi en un nas. http://plugout.net/viewtopic.php?f=31&t=1880 llevo tiempo intentando encontrar la forma de hacer que una de mis raspberry se comporte como un nas. configurando samba, minidlna, transmision, ftp, nfs, etc. pues con esta distribución lo tengo todo hecho. lo instalé ayer y me tiene soprendido. ahora mi raspi es un nas, hecho y derecho. caracterísitcas. - interfaz web. que cambia en función de si eres el administrador o un usuario. - gestión de usuarios. puediendo dar distintos permisos carpetas y funciones. - gestión de carpetas - vpn - ftp - nfs - webdav - varios servidores dlna como minidlna, townky, etc - varios gestores de descarga como transmision, mldonkey, etc - gestión de periféricos usb como impresoras o webcam. - gestión de cron para automatizar procesos. - creo que se basa en arch linux. por cierto, estoy creando una tarea para que me exporte un archivo txt del dis...
Read more

Rasperry Wifi LAN Controller - Raspberry Pi Forums

-
i'm looking way roaming = 0 in lan, can't figure how it... i'm looking in hostpd.conf , here 802.11r / iapp etc... has managed roaming = 0 system? got lan multiple wired pi ap running in bridge mode eth0 , wlan0. separated ssid, , time change 1 other long. please advice me, thanks. br i have not tried setting pi access point wireless admin , note seem saying each pi has separate ssid. mean device needs learn every pi's ssids , not roam new pi until connection previous 1 gets bad, @ point device re authenticate next pi, causing drop , reconnect, not roam. wireless roaming want use extended service set (ess) , have each pi using exact same ssid, client doesn't need reauth or , can associate same ssid different pi. of course want make sure each pi set different wireless channel don't interfere each other. sorry can't offer more point in right direction. raspberrypi
Read more

Unlock car with bluetooth and car key

-
hi, we looking redo of project in arduino. advice on components use, , trouble might run in to. project goes follows: we want unlock car smartphone (eg iphone), in car, there box containig arduino chip, connected unlock functionality of car. want use bluetooth communicate car. want keep cheap possible. quote what basic arduino board should use? the board needs relays to activate electronics , should able connect bluetooth module (and battery). should have capacity run encryption algorithm security.. quote what bluetooth module should use? the module should able connect board. consume lot of battery? have intuitive interface towards iphone , android? bluetooth recommended or have security issues? i appreciate input community, first arduino project :-) regards, mathi quote from: mathi on jun 24, 2013, 06:12 pm it should have capacity run encryption algorithm security.. in view requirement factor of hundred more difficult rest of project put together. design...
Read more